You are getting an unhandled exception so its not the
'invalid_path' error. Code in a handler for the other
possible exceptions which should assist.
hth
connor
- "Vijaya Chander V.S" <srinivasa_v_at_infosys.com>
wrote: > my prog looks like this (utl_file_dir=* is
present
> in initSID.ora file):
>
> DECLARE
> fileHandler UTL_FILE.FILE_TYPE;
> BEGIN
> dbms_output.put_line('1');
> fileHandler :=
> UTL_FILE.FOPEN('/users/vijay', 'myoutput.lst', 'W');
> dbms_output.put_line('2');
> UTL_FILE.PUTF(fileHandler, 'hai vijay \n');
> UTL_FILE.FCLOSE(fileHandler);
> EXCEPTION
> WHEN utl_file.invalid_path THEN
> raise_application_error(-20000, 'ERROR:
> Invalid path for file.');
> END;
>
> and when i am running this script i am getting a
> message like this:
>
> 1
> DECLARE
> *
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.UTL_FILE", line 101
> ORA-06512: at "SYS.UTL_FILE", line 157
> ORA-06512: at line 5
>
> what can be the problem...
>
> regards,
> vijay
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Vijaya Chander V.S
> INET: srinivasa_v_at_infosys.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jun 21 2002 - 08:43:23 CDT