Hi,
I want to create a trigger in oracle with exception handling:
Trigger from sm1-table:
begin
insert into test1@schufadb (wert) values (:new.wert);
EXCEPTION
WHEN OTHERS THEN
insert into sm1 (wert) values ('test');
end;
The Problem is, if an exception occures the trigger can´t do the insert
in his table. How can a table's trigger insert into it's self.
thanx and regards
Stephan
