Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent: UTL_FILE package not working 8.0.6

Re: Urgent: UTL_FILE package not working 8.0.6

From: Akram JARO <ajaro_at_synavant.com>
Date: Thu, 5 Oct 2000 10:50:14 +0200
Message-ID: <OjXC5.26$cf6.1824@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 Thu Oct 05 2000 - 03:50:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US