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

Home -> Community -> Usenet -> c.d.o.misc -> UTL_FILE/Personal Oracle 8.0.3.0.0/Win98 - PLEASE HELP!

UTL_FILE/Personal Oracle 8.0.3.0.0/Win98 - PLEASE HELP!

From: Artur <parafiniuk_at_hotmail.com>
Date: Fri, 02 Apr 1999 03:41:23 GMT
Message-ID: <D%WM2.19528$R92.11665@news20.bellglobal.com>


Hi,

I have problem opening file using UTL_FILE.FOPEN. It raises UTL_FILE.INVALID_PATH exception. File 'C:\NETLOG.TXT' exists. I can open it using notepad.

Why I have the problem?

Here is the procedure:

declare

file_handle UTL_FILE.FILE_TYPE;
path_ char(3) := 'C:\';
file_ char(10) := 'NETLOG.TXT';

begin

   file_handle := UTL_FILE.FOPEN(path_, file_, 'r');    UTL_FILE.FCLOSE(file_handle);
   exception

           when UTL_FILE.INVALID_MODE then dbms_output.put_line('Error: Invalid mode');

           when UTL_FILE.INVALID_FILEHANDLE then dbms_output.put_line('Error: Invalid filehandle');

           when UTL_FILE.INVALID_OPERATION then dbms_output.put_line('Error: Invalid operation');

           when UTL_FILE.READ_ERROR then dbms_output.put_line('Error: Read error');

           when UTL_FILE.WRITE_ERROR then dbms_output.put_line('Error: Write error');

           when UTL_FILE.INTERNAL_ERROR then dbms_output.put_line('Error: Internal error');

           when UTL_FILE.INVALID_PATH then dbms_output.put_line('Error: Invalid path');
end;
/ Received on Thu Apr 01 1999 - 21:41:23 CST

Original text of this message

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