Remote database... PROBLEM!

From: leo <nomail_at_nomail.nomail>
Date: Mon, 17 Apr 2000 15:29:32 +0200
Message-ID: <8df3jm$iqg$1_at_as102.tel.hr>

Main database: Oracle 7.1.5.2.3. (OpenVMS) Remote database: Oracle 8.0.5. (Linux)

Problem: inserting into remote database from any stored procedure or trigger.....

Plain SQL works just fine... (desc, select...)

   but when I use procedure or trigger............................

SQL> r

    CREATE OR REPLACE TRIGGER "MY_TRIGGER" BEFORE INSERT OR DELETE OR UPDATE ON MY_TABLE
    DECLARE
       ...
    BEGIN
    INSERT INTO OTHER_TABLE_at_REMBASE (FIELD1) VALUES (VALUE);     END;
CREATE OR REPLACE TRIGGER "KONTROLA_PERIODA" BEFORE INSERT OR DELETE OR UPDATE ON MY_TABLE *
ERROR at line 1:
ORA-04052: error occurred when looking up remote object USER.OTHER_TABLE_at_REMBASE.WORLD
ORA-04029: error ORA-1460 occurred when querying ORA_KGLR7_IDL_SB4_at_REMBASE.WORLD

ORA-00604: error occurred at recursive SQL level 1
ORA-01460: unimplemented or unreasonable conversion requested
ORA-02063: preceding line from REMBASE

Received on Mon Apr 17 2000 - 15:29:32 CEST