How to use UTL_FILE in procedure?

[bsatheesh]

Hi,

I want to log results of a procedure in a system log file. I have declared

handle UTL_FILE.FILE_TYPE;
begin
handle := UTL_FILE.FOPEN('/usr/x','logfile','w');
UTL_FILE.PUTF('success of proc');

But it gave sql error at line one (declaration).

Can I declare and use UTL_FILE inside a procedure?

Or it should be called from shell script? How to write the results in a log file?

pl. suggest me a solution.

thanks,
satheesh

[sreddy]

You need to have utl_file_dir setup for the database. Its one of the init.ora parameters. User writing to utl_file_dir should be having read,write permissions on the directory.

[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/utl_file.htm#998101[/url]
[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/utl_fil2.htm[/url]

[Edited by sreddy on 02-09-2001 at 01:42 PM]