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

Last updated on JUNE 22, 2023

Applies to:

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