Re: Urgent: UTL_FILE package not working 8.0.6

You might try an additional '/' after utl_files.

>We got error message when try to use Oracle's UTL_FILE package (please
>see below). The path /users/rpauser/dat/stage/utl_files is in the
>init.ora file.
>
>Does anyone know what else could cause the problem?
>
>Your help is highly appreciated.
>
>Jerry Li
>jerryli1_at_hotmail.com
>-----------------------------------------------------------
>SQL> l
> 1 declare
> 2 v_file utl_file.file_type;
> 3 Begin
> 4
> 5 v_file := utl_file.fopen
>('/users/rpauser/dat/stage/utl_files', 'test_io.txt', 'w');
> 6 utl_file.putf(v_file, 'test IO');
> 7 utl_file.fclose(v_file);
> 8* End;
>SQL> /
>declare
>*
>ERROR at line 1:
>ORA-06510: PL/SQL: unhandled user-defined exception
>ORA-06512: at "SYS.UTL_FILE", line 101
>ORA-06512: at "SYS.UTL_FILE", line 157
>ORA-06512: at line 5
>
>
Received on Wed Oct 04 2000 - 21:26:35 CDT