OraFAQ Forum: SQL & PL/SQL » Problem with the UTL

Home » SQL & PL/SQL » SQL & PL/SQL » Problem with the UTL_FILE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with the UTL_FILE [message #235145]

Fri, 04 May 2007 03:14

newbie_oracle
Messages: 3
Registered: May 2007

Junior Member

Hi,
I have a informatica job which inturn calls a stored procedure.I have access to the UTL_FILE directory.But I am getting the following error.

PRE-SESS> TM_6159 Error executing stored procedure...
TM_6159 [4294965496] [
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 714
ORA-06512: at "TEST.PKG_TEST", line 782
ORA-29289: directory access denied
ORA-06512: at line 2

Can you please help me out in fixing this error?
Thanks in advance.
Newbie

Report message to a moderator

Re: Problem with the UTL_FILE [message #235152 is a reply to message #235145]

Fri, 04 May 2007 03:24

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think

Quote:

directory access denied

is quite clear.
Grant access rights to oracle instance owner.

Regards
Michel

Report message to a moderator

Re: Problem with the UTL_FILE [message #235157 is a reply to message #235152]

Fri, 04 May 2007 03:33

newbie_oracle
Messages: 3
Registered: May 2007

Junior Member

Hi Michel,

Thanks a lot for your immediate reply.
I have the access to the Oracle instance from where the procedure is being called and also I have access to the UTL_FILE directory.Any idea is there anything else I need to check?

Thanks & Regards,
Newbie

Report message to a moderator