Package UTL_FILE Invalid Path
From: thierry merlin <t.merlin_at_citb.bull.net>
Date: 1998/01/22
Message-ID: <01bd2722$89cb1100$3c4c5ac0_at_thierry.citb.bull.net>#1/1
[Quoted] Already, "Invalid Path" appears. I don't know why ? I declare in Initbase.ora :
UTL_FILE_DIR='d:\temp'
Date: 1998/01/22
Message-ID: <01bd2722$89cb1100$3c4c5ac0_at_thierry.citb.bull.net>#1/1
Hi,
I wrote this :
DECLARE
file_handlerin UTL_FILE.FILE_TYPE;
BEGIN
[Quoted] file_handlerin := UTL_FILE.FOPEN ('d:\temp\','essai.txt','r');
EXCEPTION
[Quoted] [Quoted] 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;
[Quoted] 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 CET