ORA-02019 ORA-2083 ORA-2063 DURING REMOTE INSERT
(Doc ID 1484079.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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, ' ||
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.
ORA-02083: database name has illegal character '!'
ORA-02063: preceding line from ERP_APPP
SQL> select * from t1@ERP_APPP;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!