Have you ensured that UTL_FILE_DIR in your init.ora file includes an entry
for C:\
Artur wrote in message ...
>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 Wed Mar 31 1999 - 22:24:55 CST
