Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Package UTL_FILE Invalid Path

Package UTL_FILE Invalid Path

From: thierry merlin <t.merlin_at_citb.bull.net>
Date: 1998/01/22
Message-ID: <01bd2722$89cb1100$3c4c5ac0@thierry.citb.bull.net>#1/1

Hi,
I wrote this :
DECLARE
        file_handlerin UTL_FILE.FILE_TYPE;
BEGIN
        file_handlerin := UTL_FILE.FOPEN ('d:\temp\','essai.txt','r'); EXCEPTION

	WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('No Data');
	WHEN UTL_FILE.INVALID_PATH THEN DBMS_OUTPUT.PUT_LINE('Invalid Path');
	WHEN UTL_FILE.INVALID_MODE THEN DBMS_OUTPUT.PUT_LINE('Bad Mode');
	WHEN UTL_FILE.INVALID_OPERATION THEN DBMS_OUTPUT.PUT_LINE('Bad Open');	
	WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Other');
END;
Already, "Invalid Path" appears. I don't know why ? I declare in Initbase.ora :
UTL_FILE_DIR='d:\temp'

Thank's for your help. Received on Thu Jan 22 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US