RE: Urgent : UTL file problem

Hi ,

   Check If you have the write access on the directory specified in initSID.ora file .....

Regards
Gholam

> -----Original Message-----
> From: Vijaya Chander V.S [SMTP:srinivasa_v_at_infosys.com]
> Sent: Friday, June 21, 2002 4:28 PM
> To: Multiple recipients of list ORACLE-L
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ahmed Gholam Hussain
  INET: ahussain_at_gisqatar.org.qa

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).