Urgent: UTL_FILE package not working 8.0.6

From: <zuot_at_my-deja.com>
Date: Wed, 04 Oct 2000 19:14:00 GMT
Message-ID: <8rfvhg$egf$1@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 Wed Oct 04 2000 - 14:14:00 CDT