Home » SQL & PL/SQL » SQL & PL/SQL » Problem with the UTL_FILE
Problem with the UTL_FILE [message #235145] Fri, 04 May 2007 03:14 Go to next message
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

Re: Problem with the UTL_FILE [message #235152 is a reply to message #235145] Fri, 04 May 2007 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think
Quote:
directory access denied

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

Regards
Michel
Re: Problem with the UTL_FILE [message #235157 is a reply to message #235152] Fri, 04 May 2007 03:33 Go to previous messageGo to next message
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

Re: Problem with the UTL_FILE [message #235160 is a reply to message #235145] Fri, 04 May 2007 03:44 Go to previous messageGo to next message
orasupport
Messages: 11
Registered: May 2007
Junior Member
Check for any typo in the path/file name? Check whether it exists.
Re: Problem with the UTL_FILE [message #235161 is a reply to message #235157] Fri, 04 May 2007 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
YOU have access but does the INSTANCE OWNER has access?
You read/write through Oracle.

Regards
Michel
Re: Problem with the UTL_FILE [message #235169 is a reply to message #235161] Fri, 04 May 2007 04:07 Go to previous messageGo to next message
newbie_oracle
Messages: 3
Registered: May 2007
Junior Member
Yes the instance owner is having the access.
Re: Problem with the UTL_FILE [message #235180 is a reply to message #235169] Fri, 04 May 2007 04:20 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So check what "orasupport" said.

Regards
Michel
Previous Topic: Query Tuning
Next Topic: table content comparison
Goto Forum:
  


Current Time: Mon Dec 05 21:35:06 CST 2016

Total time taken to generate the page: 0.09674 seconds