creating text files

[jbenh]

I need to create a text file from production data using PL/SQL on Oracle 8i on HPUX v11. A quick search of OTN was no luck.

Thanks,

Ben

 

[spicysudhi]

DECLARE
L_STR VARCHAR2(4000);
L_OUTPUT UTL_FILE.FILE_TYPE;
BEGIN
L_OUTPUT := UTL_FILE.FOPEN('d:\','test.txt', 'W');
L_STR := 'Sample test message to file';
UTL_FILE.PUT_LINE(L_OUTPUT,L_STR);
UTL_FILE.FCLOSE( L_OUTPUT );
EXCEPTION
WHEN OTHERS THEN
UTL_FILE.FCLOSE( L_OUTPUT );
END;


Note: give the directory permission in init.ora file by setting the utl_file_dir variable.

-Sudhi

 

[jbenh]

Thanks. I revised my search and found that the 9i database online documentation was available at

http://www.engin.umich.edu/caen/wls/software/oracle/

I appreciate your quick response.

Ben