Re: utl_file

Goran Sokol wrote:
>
> 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?

   UTL_FILE have its own exceptions raised with RAISE_APPLICATION_ERROR    See documentation and package specification.

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia