OWS 3.1.8 and UTL_FILE package write problems

   I've got a small pl/sql procedure that writes out a few lines to a log file. If I run the procedure interactively using sql*plus, the data is written to the file. However, when I run the exact same procedure (in the same schema) from the oracle web server's pl/sql cartridge, nothing happens yet no errors are raised.

Procedure Source:
CREATE OR REPLACE PROCEDURE m_test IS
SCL utl_file.file_type;
BEGIN
/* Create a file handle to the output file in the append mode. */
   SCL := utl_file.fopen('/tmp', 'SchdChgLog', 'a');

/* Write the output line. (obviously, more meaningful data goes here.)
*/

   utl_file.putf(SCL, '%s %s \n', 'schdchglog','test');

/* Flush the output file and then close it. */
   utl_file.fflush(SCL);
   utl_file.fclose(SCL);

EXCEPTION
   WHEN OTHERS THEN
      htp.p('<!--- CHANGE LOG NOT WRITTEN - ERROR CONDITION -->'); END; Thanks for any help,

Mike Resnick
resnimi_at_mail.northgrum.com
bigrez_at_mail.hughes.net Received on Tue Nov 02 1999 - 00:39:17 CST