Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Why not getting INVALID_PATH?
Small piece of code utilizing UTL_FILE package.
I'm trying to open up a file that does not exist -
and I am getting - through use of an OTHERS handler
SQLCODE=1
SQLERRM=User defined exception.
I haven't defined any exceptions.
I'm wondering why I don't get "Invalid_path"
Remember..the file is non-existent
Here's the code
create or replace procedure foo as
location VARCHAR2(30) :=/home/dropship filename VARCHAR2(30; open_mode VARCHAR2(30):='r'; handle UTL_FILE.FILE_TYPE;
SQL> exec foo;
1 User-Defined Exception
Others exception handler
PL/SQL procedure successfully completed.
Shouldn't I get Invalid Path?
And if not Invalid path, why user defined? I didn't define anything...
![]() |
![]() |