ORA-02019 ORA-2083 ORA-2063 DURING REMOTE INSERT
(Doc ID 1484079.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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 <schema.tablename>
ORA-00604: error occurred at recursive SQL level 1
ORA-02019: connection description for remote database not found.
ORA-02063: preceding 3 lines from <dblink>
ORA-06512: at "<schema.procedure_name>", line 1034
The point where the errors are returned is during the procedure <procedure_name> in the following SQL Statement execution.
l_sql_stmt := ' INSERT INTO <tablename>' || l_dblink ||
' ( col1, '||
' col2, ' ||
' col3, ' ||
SQL> Create database link <dblink> connect to <user> identified by <pwd> using '<tns_Connect_String>';
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 <dblink>
SQL> select * from t1@<dblink>;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!