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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
