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 <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >From: "Vijaya Chander V.S" <[EMAIL PROTECTED]> >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: [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).
---------------------------------------------------- Torben Holm Miracle A/S Mobil : +45 2527 7104 [EMAIL PROTECTED] http://miracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).