Re: utl_file

Hello,

check if utl_file_dir is set to a given directory: select value from v$parameter where name = 'utl_file_dir' if not:

stop your database
add parameter utl_file_dir = <Directory> to your init<SID>.ora restart your database

recheck
select value from v$parameter where name = 'utl_file_dir' and try your code.

Best regards,
PGI "Goran Sokol" <goran.sokol_at_zaba.hr> wrote in message news:<9o4nls$1i3h$1_at_as201.hinet.hr>...
> Hi!
>
> I have some problems with utl_file package on 7.3.3 for AIX (utl_file_dir in
> init oracle_sid.ora is setup to *).
>
> SQL> r
> 1 declare
> 2 han UTL_FILE.FILE_TYPE;
> 3 loc constant varchar2(20) := '/vendor/';
> 4 fne constant varchar2(20) := 'proba.txt';
> 5 begin
> 6 han := utl_file.fopen(loc, fne, 'w');
> 7 utl_file.put_line(han, 'bla bla');
> 8 utl_file.fclose(han);
> 9* end;
> declare
> *
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.UTL_FILE", line 85
> ORA-06512: at "SYS.UTL_FILE", line 120
> ORA-06512: at line 6
>
>
> Any ideas?
>
> Goran
Received on Tue Sep 18 2001 - 02:08:33 CDT