utl_file

From: Goran Sokol <goran.sokol_at_zaba.hr>
Date: Mon, 17 Sep 2001 13:43:33 +0200
Message-ID: <9o4nls$1i3h$1@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 Mon Sep 17 2001 - 06:43:33 CDT