Re: Urgent: UTL_FILE package not working 8.0.6

hi,
add an exception handler in your source to show the error details.

begin

    ;
exception

    when invalid_path then
    dbms_output('path error ...
end;

"Akram JARO" <ajaro_at_synavant.com> schrieb im Newsbeitrag news:OjXC5.26$cf6.1824_at_nreader1.kpnqwest.net...
> hi
> you can also check your permissions.
> chmod 750 *
> ciao
> @kram JARO
> <zuot_at_my-deja.com> schrieb in im Newsbeitrag:
 8rfvhg$egf$1_at_nnrp1.deja.com...
> > 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
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

>
> Received on Mon Oct 09 2000 - 16:44:43 CDT