Re: Package UTL_FILE Invalid Path

thierry merlin wrote:
>
> 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.

  Thierry,

  Try to remove apostrophes from directory_name in your   UTL FILE DIR parameter

     EXAMPLES:          UTL_FILE_DIR = /u05/home/output/mydir, /output

         or

         UTL_FILE_DIR = *    Slava. Received on Thu Jan 22 1998 - 00:00:00 CST