Hi

Check the utl_file_dir parameter will got a path.

Check if the path oracle account own right privilege or exist.

You can find utl_file_dir parameter via

SQL>select * from v$parameter where name = 'utl_file_dir'

or

SQL> Show parameter utl_file_dir

Wilson

"Somebody please tell me, if 640MB ought to be enought for VISTA" - Wilson Shen , 2007



-----Original Message-----
From: caffeine-addict
[mailto:oracledba-ezmlmshield-x38376178.[Email address protected]
Sent: Wednesday, August 08, 2007 2:36 PM
To: LazyDBA Discussion
Subject: Re: Oracle error


Looks like you do not have your UTL_FILE paramter setup in your init.ora.

LS

"640KB ought to be enough for anybody." - Bill Gates, 1981



----- Original Message ----
From: Nidhin_Zachariah <oracledba-ezmlmshield-x25308757.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Tuesday, August 7, 2007 1:38:24 AM
Subject: Oracle error


Hi, I am coming across an oracle error while executing a procedure.

This procedure will write some file to a particular folder and the
log file show the below errors message after the execution.

" ORA-29280 :Invalid directory path"
" ORA-06512 at "SYS_UTL_FILE", line 18
I am wondering about this error as I have admin privilege in this
box.

Could you please help me to resolve this issue?

Regards
Nidhin Zachariah






DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page