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!

INSERT TRIGGER --> Prevent the insert

142083Mar 6 2007 — edited Mar 6 2007

Hallo,

via insert (before/after) trigger I want to prevent on given criterias the row insert or delete the new row.
I have try to delete the row on "after insert" --> without success.
Also to call an exception on "before insert" --> the same.
Any other ideas?
Thanks!

Regards
Michael

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2007

Added on Mar 6 2007

19 comments

14,359 views