UTL_FILE question

From: Olaf F. Normann <olafn_at_runit.no>
Date: Mon, 22 Oct 2001 10:14:24 +0200
Message-ID: <1003738464.664390_at_halvan.trd.sintef.no>

Hello all Oracle experts!
[Quoted] [Quoted] I try to use the UTL_FILE packages, but when I execute the following script, I get trapped in the exeption regardless of which path I enter (I got the script from http://www.orafaq.com/faqplsql.htm).

Do I need to enter anything in the "INIT.ORA" file? If so, how is the format?

Please help!!

Best regards
Olaf F. Normann

[Quoted] --snipp----snipp----snipp----snipp----snipp----snipp--

DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
fileHandler := UTL_FILE.FOPEN('f:\oracle', 'myfile', '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, 'FEIL: Invalid path for file or path not in INIT.ORA.');
END; Received on Mon Oct 22 2001 - 10:14:24 CEST