Package Creation On Oracle 9iR2(9.2.0X) Accessing Remote PROCEDURE By SYNONYM On Oracle 10gR1/10gR2 (10.1.0.2 up to 10.2.0.3) fails by ORA-04052 / ORA-06544: [1907] / ORA-06553: PLS-00801: [1907] (Doc ID 340597.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
PL/SQL - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Sep-2013***


Symptoms

Creation of a PACKAGE on local Oracle9iR2 (9.2.0.x) RDBMS that access a remote PROCEDURE through a SYNONYM on Oracle10gR1/10gR2 (10.1.0.2 up to 10.2.0.3) fails with:

CREATE OR REPLACE PACKAGE BODY PROC AS
*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object SCHEMA.PACKAGE@DBLINK
ORA-06544: PL/SQL: internal error, arguments: [1907], [], [], [], [], [], [],[]
ORA-06553: PLS-801: internal error [1907]


or

ORA-04052: error occurred when looking up remote object SCHEMA.PACKAGE@DBLINK
ORA-06544: PL/SQL: internal error, arguments: [1803], [], [], [], [], [], [],
ORA-06553: PLS-707: unsupported construct or internal error [1803]


or

ORA-04052: error occurred when looking up remote object SCHEMA.PACKAGE@DBLINK
ORA-06544: PL/SQL: internal error, arguments: [1401], [], [], ...
ORA-06553: PLS-801: internal error [1401]


When accessing a remote Oracle9i(9.2.0.X) Database from a local Oracle10gR1/10gR2 (10.1.0.2 up to 10.2.0.3) Database thru a DATABASE LINK it fails by

ORA-04052: error occurred when looking up remote object SCHEMA.PACKAGE@DBLINK
ORA-06541: PL/SQL: compilation error - compilation aborted
ORA-06553: PLS-908: The stored format of SCHEMA.PACKAGE@DBLINK is not supported by this release

 or

CREATE OR REPLACE PACKAGE BODY TEST_CUSTOMERJOIN IS
*
ERROR at line 1:
ORA-4052: error occurred when looking up remote object KKDB.TEST_KKDB_CUSTOMERJOIN@KKDBDEV.WORLD
ORA-6544: PL/SQL: internal error, arguments: [1801], [], [], [], [], [], [],[]
ORA-6553: PLS-707: unsupported construct or internal error [1801]

Changes

The Remote database was upgraded from Oracle 9iR2(9.2.0.X) to  Oracle 10gR1/10gR2 (10.1.0.2 up to 10.2.0.3)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms