OraFAQ Forum: SQL & PL/SQL » UTL

Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE [message #37182]

Tue, 22 January 2002 22:55

mohamed
Messages: 27
Registered: November 2001

Junior Member

i have a problem with UTL_FILE package
i used the following procedure

----------------------------------
create or replace procedure test_spol
IS
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
fileHandler := UTL_FILE.FOPEN('myfolder', 'myfolder.sql', 'w');
UTL_FILE.PUTF(fileHandler, 'Look ma, I''m writing to a file!!!n');
UTL_FILE.FCLOSE(fileHandler);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: Invalid path for file or path
not in INIT.ORA.');
END test_spol;
---------------------------------------

and i put in the init.ora the following path
UTL_FILE_DIR = "C:"

with folder named myfolder on the path "c:"

after that i recieve the exception alert

can u help me in this problem

thanks for interest

Report message to a moderator