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