Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04052: error occurred when looking up remote object
ORA-04052: error occurred when looking up remote object [message #236492] Thu, 10 May 2007 01:56 Go to next message
pati1984
Messages: 3
Registered: September 2005
Location: Poland
Junior Member
I have a problem. I use select:

select item1,item2,item3
from table@db_link;

in the PL/SQL package. When I try to compile this package I get errors:

PL/SQL: ORA-04052: error occurred when looking up remote object table@db_link
ORA-00604: error occurred at recursive SQL level 1
ORA-03120: two-task conversion routine: integer overflow


Do you have any ideas what is the reason and how can I solve this problem?
Re: ORA-04052: error occurred when looking up remote object [message #236497 is a reply to message #236492] Thu, 10 May 2007 02:05 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have a db link to a non-Oracle database? Maybe it contains values that Oracle don't support.

Did you recently apply a patch? Either on local or remote database Oracle home?

Regards
Michel
Previous Topic: What is INSTEAD OF TRIGGER
Next Topic: New Guy With Question
Goto Forum:
  


Current Time: Fri Dec 02 22:58:14 CST 2016

Total time taken to generate the page: 0.08560 seconds