Re: Urgent : UTL file problem

From: Gene Sais <Gsais_at_co.palm-beach.fl.us>
Date: Fri, 21 Jun 2002 08:48:54 -0800
Message-ID: <F001.00484485.20020621084854@fatcity.com>

can you create a file in /users/vijay as the user oracle? remember oracle is the writer & needs access to do so.

hth,
gene

>>> srinivasa_v_at_infosys.com 06/21/02 07:58AM >>>
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: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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 - 11:48:54 CDT