Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE
UTL_FILE [message #37182] Tue, 22 January 2002 22:55 Go to next message
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
Re: UTL_FILE [message #37184 is a reply to message #37182] Wed, 23 January 2002 02:21 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

have u restart the database after changing init.ora, for chage to take effect.

by the way what error u r getting.

cheers
pratap
Re: UTL_FILE [message #37189 is a reply to message #37182] Wed, 23 January 2002 09:33 Go to previous message
raghav banuru
Messages: 6
Registered: January 2002
Junior Member
you cannot write to c: you can creat the file in the server only

all the best
raghav.
Previous Topic: Pl/SQL Store procedure size too large -PLS-00123
Next Topic: comparing two tables data
Goto Forum:
  


Current Time: Mon Aug 02 10:37:58 CDT 2021