Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is possible Cancel Insert in a trigger?

322209Aug 12 2002
I have to split and insert records in a diferent tables based in one table.

I mean i want when i insert 1 record in table A, this info be copied to table B but this record deleted or canceled in table A.

Example of trigger on table A(id,name):

trigger x before insert
for each row
begin
if test then
insert into table b(id,name)
(new.id,new.name);
end if ;
end;

I can copy the record to table B but HOW do i delete or cancel the record to be inserted into table A ?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2002
Added on Aug 12 2002
2 comments
831 views