Do you miss a / at the end of the path?
/torben
>-- Original Message --
>Date: Fri, 21 Jun 2002 03:58:19 -0800
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Reply-To: ORACLE-L_at_fatcity.com
>From: "Vijaya Chander V.S" <srinivasa_v_at_infosys.com>
>Subject: Urgent : UTL file problem
>
>
>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).
Torben Holm
Miracle A/S
Mobil : +45 2527 7104
torben.holm_at_miracleas.dk
http://miracleAS.dk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: torben.holm_at_miracleas.dk
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 - 07:37:21 CDT
