DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Defining trigger actions over remote tables

  1. #1
    Join Date
    May 2005
    Posts
    1

    Defining trigger actions over remote tables

    As of today I am facing a terrible problem with defining trigger updates and deletes on remote tables.

    Consider a view X created as:

    create view X as
    select «columns» from
    X@«dblink»

    I then define a trigger over that view in the following way:

    create or replace trigger X_t
    instead of insert or update or delete on X
    for each row
    begin
    if inserting then «insert on X@«dblink»»
    end if;

    if updating then «update on X@«dblink»»
    end if;

    if deleting then «delete on X@«dblink»»
    end if;
    end;
    /

    When I insert tuples on view X, the insertion is propagated successfully.

    However, when I update or delete over view X, I get the infamous:

    ORA-03113: end-of-file on communication channel

    I am practically despairing as I have searched and searched for ways to workaround this problem and I just can't understand what's wrong with my code.

    Oracle version: 9.2.0.1.0 on XP
    Last edited by Kodachi; 05-21-2005 at 01:35 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width