RE: Urgent : UTL file problem

vijay,

check the permissions for the /users/vijay directory. Directories that UTL_FILE can read from and write to must have permissions of the Oracle instance owner and the user running the package. Also, utl_file_dir=* is not recommended.

Catalin

> -----Message d'origine-----
> De: Vijaya Chander V.S [mailto:srinivasa_v_at_infosys.com]
> Date: vendredi 21 juin 2002 13:58
> A: Multiple recipients of list ORACLE-L
> Objet: 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: Nastase, Mr. C. (Catalin)
  INET: CNastase_at_primagaz.fr

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