Database Links

From: Tim Kelly <tkelly_at_entec-systems.com>
Date: 20 Sep 2001 19:55:38 -0700
Message-ID: <78feea1e.0109201855.38b8be5_at_posting.google.com>


I have two databases. One Oracle 8i v8.1.7 running on openVMS and one Oracle 7.3.5 running on NT. Both databases are setup with the distributed database option. I have created a database link on the OpenVMS system to the NT system. When I run SQLPLUS I can use the database link to view the tables on the the NT system.

I have a trigger on the VMS system which I want to use to update the NT tables. I get a ORA-02019 error when the PL/SQL code runs.

Anyone have any ideas.

thanks Received on Fri Sep 21 2001 - 04:55:38 CEST

Original text of this message