| Ora-04052 error plz help!!! [message #241684] |
Wed, 30 May 2007 07:07  |
mr_dba01
Messages: 5
Registered: May 2007
Location: mumbai
|
Junior Member |
|
|
Dear all,
While running a procedure I have received following error:
**************************************************************
Ora-04052 Error occurred looking up remote object ABNOPR.DATAMART_FLG@DATAMART
Description:
ORA-04052: error occurred when looking up remote object stringstringstringstringstring
Cause: An error has occurred when trying to look up a remote object.
Action: Fix the error. Make sure the remote database system has run KGLR.SQL to create necessary views used for querying/looking up objects stored in the database.
*****************************************************************
Is this error from the application side?? What action should have been taken? The table is present on remote database which is connected through database link.Please guide asap.
Thanks & Regards
Prasad
|
|
|
|
|
|
| Re: Ora-04052 error plz help!!! [message #241692 is a reply to message #241688] |
Wed, 30 May 2007 07:29  |
mr_dba01
Messages: 5
Registered: May 2007
Location: mumbai
|
Junior Member |
|
|
Dear,
In this procedure I am updating a table.When i queried the table it is giving me result.But the error pointing towards Update statement in the procedure. What is KGLR.sql?? Why it is run? Does anybody has idea.
Thanks & Regards
Prsad
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
