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