Home » SQL & PL/SQL » SQL & PL/SQL » Unwanted "object owner" in procedure causing ORA-04052 error (ORCALE 10G)
Unwanted "object owner" in procedure causing ORA-04052 error [message #284812] Sat, 01 December 2007 07:39 Go to next message
bouh52
Messages: 2
Registered: December 2007
Junior Member
Hi all,

I am running a procedure to insert data from remote database to local oracle server. error 04052 I am getting. When running same procedure in SQL works fine.

Automatically object owner of target database is added ? CMDBSC. is the “object owner” of the target database…..I am not putting this in my procedure ? why it is added automatically ? How to disable ? I am also getting ORA-03106 errors.
Can anyone please help me.
Please see attached procedure .

(1): PL/SQL: ORA-04052: error occurred when looking up remote object CMDBSC.C_BTS@OMC
(1): ORA-00604: error occurred at recursive SQL level 1
(1): ORA-03106: fatal two-task communication protocol error
(1): ORA-02063: preceding line from OMC

CREATE OR REPLACE PROCEDURE LOAD_HR_DATA_OSS1 (DATE_TIME IN VARCHAR)
IS
BEGIN
-- 1
INSERT INTO P_NBSC_RES_AVAIL_HR
SELECT OBSC.NAME BSC,
NVL (OBTS.NAME, ' ') CELL,
PERIOD_DURATION,
A.INT_ID,
BTS_ID,
AVE_NON_AVAIL_TSL,
RES_AV_DENOM1,
AVE_AVAIL_FULL_TCH,
RES_AV_DENOM2,
AVE_SDCCH_SUB,
RES_AV_DENOM33,
TIME_IN_FORCED_HR_MODE,
TIME_IN_FORCED_AMR_HR_MODE,
TIME_IN_FORCED_HR_AMR_HR_MODE,
NVL (C.SEGMENT_NAME, ' ') SEGMENT
FROM P_NBSC_RES_AVAIL@OMC A,
OBJECTS@OMC OBTS,
OBJECTS@OMC OBSC,
C_BTS@OMC C
WHERE TO_CHAR (A.PERIOD_START_TIME, 'DD-MM-YYYY') = DATE_TIME
AND A.BTS_INT_ID = OBTS.INT_ID AND OBTS.OBJECT_CLASS = 4
AND A.INT_ID = OBSC.INT_ID AND OBSC.OBJECT_CLASS = 3
AND A.BTS_INT_ID = C.INT_ID AND C.CONF_NAME = '<ACTUAL>'
AND NVL (OBTS.NAME, ' ') <> ' ';

INSERT INTO ETL_LOG
VALUES ('OSS1-03: P_NBSC_RES_AVAIL loaded.', SYSDATE);

COMMIT;

END LOAD_HR_DATA_OSS1;


Thanks
regards

Kasi (Oracle 10G user)
Re: Unwanted "object owner" in procedure causing ORA-04052 error [message #284814 is a reply to message #284812] Sat, 01 December 2007 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals) for all sides.

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.


Regards
Michel

Re: Unwanted "object owner" in procedure causing ORA-04052 error [message #284815 is a reply to message #284812] Sat, 01 December 2007 07:51 Go to previous message
bouh52
Messages: 2
Registered: December 2007
Junior Member
Thanks Michel...I have run KGLR.SQL on the source but not yet on the target database.
Previous Topic: Bulk insert
Next Topic: Newbie help,where can i download extra tables
Goto Forum:
  


Current Time: Thu Dec 08 08:31:12 CST 2016

Total time taken to generate the page: 0.08657 seconds