UTL_FILE

From: <ajayraina_at_hotmail.com>
Date: 1998/03/30
Message-ID: <6fpf3l$f6a$1@nnrp1.dejanews.com>#1/1

I have written the following Oracle PL/SQL procedure to create a small file.

create or replace procedure ajfile as
 the_file utl_file.file_type;
BEGIN

 the_file := utl_file.fopen('/proj/hedging','venk.txt','W');
 utl_file.put_line(the_file,'Hello world');
 utl_file.fclose(the_file);

EXCEPTION
 when utl_file.INVALID_PATH then
 raise_application_error(-20000, 'UTL_FILE: Invalid path'); END; I am getting the following error on execution :

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 "RAINAA.AJFILE", line 4
ORA-06512: at line 1

The parameter UTL_FILE_DIR with the path used in the program has been entered in the init<SID>.ora file which is used in the PL/SQL program. Still, this error occurs. Can anybody out there help me?

Best regards,

Ajay.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 30 1998 - 00:00:00 CST