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
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