Re: UTL_FILE : invalid_path error

Thanks a lot Thomas Kyte.
My utl parameter value was null.
I had set it in init.ora

Now I am setting it in my
initoratest1.ora file
oratest1 is my database
Now it works
Thanks again.
Regards,
Aditya

adityanath_at_hotmail.com (Aditya) wrote in message news:<4a5a78d4.0203120845.6488c1e5_at_posting.google.com>...
> Hi!
>
> I am trying to use utl_file package.
> My Oracle is on SunOS
>
> I have put in the following line in init.ora
>
> utl_file_dir = *
>
> I have restarted the Oracle server
>
> 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 Wed Mar 13 2002 - 21:15:01 CET