create or replace trigger testtrg
for delete or insert or update on BTK.AVALTYP compound trigger
pragma exception_init(anyerr, -20005);
before
begin
null;
raise anyerr;
exception
null; end
begin
after statement is
null;
exception
when others then
end after statement;
end;
[code]
thanks in advance
Wilko
Hi,
I’m using toad for oracle, latest ebf ( 10.6.1 ) and oracle 11gR2. I can create a compound trigger using pl/sql editor. But debugging will not work. Compile with debug will mark any use of exception handler as syntax error. Furthermore, if I compile the trigger without exception handler, it will not allowdebugging any statement within timing blocks.
Does anybody have experiences on that issue ?
[code]
anyerr exception; each row is when anyerr then before each row; null;