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!

Compound Trigger and Exceptions

48665Dec 27 2010 — edited Dec 27 2010
Hi,

I'm using 11gR2. It seems to be impossible writing a compound trigger including an exception handler. But I need one.
Code is
create or replace trigger testtrg
for delete or insert or update on BTK.AVALTYP compound trigger
anyerr exception;
pragma exception_init(anyerr, -20005);

before each row is
begin
  null;
  raise anyerr;
  exception
    when anyerr then
       null;
end before each row;

after statement is
begin
  null;
   EXCEPTION
     when others then
      null;
end after statement;
  
end;
any suggestions?

regards Wilko
This post has been answered by Solomon Yakobson on Dec 27 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 24 2011
Added on Dec 27 2010
6 comments
1,449 views