Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL: ORA-04052: error occurred when looking up remote object

mohsin javedDec 8 2010 — edited Dec 9 2010
Hi,

i am having 2 oracle database both on different servers one is oracle 9i and other is oracle 10g both the database are connected using dblink.

we are having same table A in both the databases. Table A in db 9i having column with data type LONG similarly Table A in 10g having column with data type CLOB.

now when i am trying to insert multiple records using pl sql block over a db link it gives following error.


Error at line 1
ORA-06550: line 4, column 5:
PL/SQL: ORA-04052: error occurred when looking up remote object ACEUAT.TEST_OFAC@ACEDBUAT
ORA-00604: error occurred at recursive SQL level 1
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from ACEDBUAT
ORA-06550: line 4, column 5:
PL/SQL: SQL Statement ignored

kindly suggest some resolution for this issue.

Thanks,

Mohsin Javed
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2011
Added on Dec 8 2010
4 comments
1,570 views