Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL: ORA-04052: error
PL/SQL: ORA-04052: error [message #320462] Thu, 15 May 2008 03:28 Go to next message
S384492
Messages: 7
Registered: June 2007
Junior Member
Hi,
I am getting the following error while compiling the fucntion.
here i am using the following query:

SELECT
A.FLTDAT,FLTHDGFLG
FROM
EXPULDMST_DN A,
EXPULDAWB_DN B,
ACCCACMST_DN C
WHERE
C.CMPCOD = B.CMPCOD
AND C.CMPCOD = B.CMPCOD
AND C.AWBOWRIDR = B.MSTOWRIDR
AND C.MSTAWBNUM = B.MSTAWBNUM
AND C.DUPNUM = B.DUPNUM
AND C.SEQNUM = B.SEQNUM
AND B.CMPCOD = A.CMPCOD
AND B.ARPCOD = A.ARPCOD
AND B.ULDNUM = A.ULDNUM(+)
AND B.FLTNUM =A.FLTNUM
AND B.FLTDAT=A.FLTDAT AND c.cacnum= numCAC;

EXPULDMST_DN A ---------> public synonym accessing from another database
EXPULDAWB_DN B ---------> public synonym accessing from another database

ACCCACMST_DN C ---------> public synonym accessing from another database

but this query is executing fine, but with in the function only i am getting the below error.

PL/SQL: ORA-04052: error occurred when looking up remote object ACC_OWNR.ACCCACMST@DRASS_DNCS_LINK
ORA-00604: error occurred at recursive SQL level 1
ORA-03120: two-task conversion routine: integer ov
Re: PL/SQL: ORA-04052: error [message #320477 is a reply to message #320462] Thu, 15 May 2008 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Does "another database" means non-Oracle ones?
In this case, you have incompatible values: some of your remote values are not supported by Oracle.

Regards
Michel
Re: PL/SQL: ORA-04052: error [message #320493 is a reply to message #320477] Thu, 15 May 2008 04:59 Go to previous messageGo to next message
S384492
Messages: 7
Registered: June 2007
Junior Member
no that one also oracle
Re: PL/SQL: ORA-04052: error [message #320497 is a reply to message #320493] Thu, 15 May 2008 05:14 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
Quote:
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.
Previous Topic: Using bulk collect and forall syntax in the procedure
Next Topic: Tunning of SQL,it fetches more than one lakh rows
Goto Forum:
  


Current Time: Mon Feb 17 04:16:20 CST 2025