-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|