Click to See Complete Forum and Search --> : Oracle Trigger


StephanM1
April 18th, 2001, 08:30 AM
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