UTL_FILE : invalid_path error

From: Aditya <adityanath_at_hotmail.com>
Date: 12 Mar 2002 08:45:38 -0800
Message-ID: <4a5a78d4.0203120845.6488c1e5_at_posting.google.com>

Hi!

I am trying to use utl_file package.
[Quoted] My Oracle is on SunOS

[Quoted] [Quoted] I have put in the following line in init.ora

utl_file_dir = *

I have restarted the Oracle server

[Quoted] And my code is

Create Or Replace Procedure sp_report_data IS

ls_string		varchar2(1000);
file_id			UTL_FILE.FILE_TYPE;

Begin

   dbms_output.put_line ('before open');
   file_id      := UTL_FILE.FOPEN ('/u12/dashboard', 'Error.txt', 'W');
   dbms_output.put_line ('after open');

   ls_string := 'data uploaded successfully';    UTL_FILE.PUT (file_id,ls_string);
   UTL_FILE.FCLOSE (file_id);

  EXCEPTION

  WHEN UTL_FILE.INVALID_PATH THEN
    dbms_output.put_line('path not valid');
  WHEN UTL_FILE.INVALID_MODE THEN
    dbms_output.put_line('file mode not valid');
  WHEN UTL_FILE.INVALID_OPERATION THEN
    dbms_output.put_line('file operation not valid');

End;

It is going into the exception UTL_FILE.INVALID_PATH just after UTF_FILE.FOPEN statement.

Any suggestion is highly appretiated.

Regards,
Aditya
adityanath_at_hotmail.com Received on Tue Mar 12 2002 - 17:45:38 CET