PL/SQL: ORA-04052: error [message #320462] |
Thu, 15 May 2008 03:28  |
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 #320497 is a reply to message #320493] |
Thu, 15 May 2008 05:14  |
 |
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.
|
|
|
|