My Oracle Support Banner

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 11.2.0.1 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.

Symptoms

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, ' ||

Testcase:

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.

SQL> commit;

Commit complete.

SQL> insert into t1@<dblink> select * from t2;
insert into t1@<dblink> select * from t2

ORA-02083: database name has illegal character '!'
ORA-02063: preceding line from <dblink>


SQL> commit;

Commit complete.

SQL> select * from t1@<dblink>;

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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.