Toad World® Forums

Debugging coumpound triggers


#1

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;