ORA-02019 ORA-2083 ORA-2063 DURING REMOTE INSERT (Doc ID 1484079.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When trying to release a plan, received the following errors.

ORA-04052: error occurred when looking up remote object MSC.MSC_PLANS@!
ORA-00604: error occurred at recursive SQL level 1
ORA-02019: connection description for remote database not found.
ORA-02063: preceding 3 lines from ERP
ORA-06512: at "APPS.MSC_REL_PLAN_PUB", line 1034

The point where the errors are returned is during the procedure POPULATE_ISO_IN_SOURCE in the following SQL Statement execution.

l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||
                '  ( batch_id, '||
                '    Item_ID, ' ||
                '    SRC_Organization_ID, ' ||

Testcase:

SQL> Create database link ERP_APPP connect to app1 identified by app1 using 'ERP';

Database link created.

SQL> insert into t2 values(12,'bbb2');

1 row created.

SQL> commit;

Commit complete.

SQL> insert into t1@ERP_APPP select * from t2;
insert into t1@ERP_APPP select * from t2

ORA-02083: database name has illegal character '!'
ORA-02063: preceding line from ERP_APPP


SQL> commit;

Commit complete.

SQL> select * from t1@ERP_APPP;

        A B
---------- ----------
        1 aaa
        1 bbb

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