-
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
-
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.
http://technet.oracle.com/docs/produ...ile.htm#998101
http://technet.oracle.com/docs/produ...6/utl_fil2.htm
[Edited by sreddy on 02-09-2001 at 01:42 PM]
