SQLnav cannot create COMPOUND triggers?

– Test table:

CREATE TABLE mpa_employees (id NUMBER, emp_name VARCHAR2(255));
/

– Creating Trigger:

CREATE OR REPLACE TRIGGER mpa_compound_test
FOR INSERT OR DELETE OR UPDATE OF emp_name
ON mpa_employees
COMPOUND TRIGGER

l_temp CONSTANT NUMBER := 200;

BEFORE STATEMENT IS
BEGIN
dbms_output.put_line(‘BS’);
END BEFORE STATEMENT;

BEFORE EACH ROW IS
BEGIN
dbms_output.put_line(‘BR’);
END BEFORE EACH ROW;

AFTER EACH ROW IS
BEGIN
dbms_output.put_line(‘AR’);
END AFTER EACH ROW;

AFTER STATEMENT IS
BEGIN
dbms_output.put_line(‘AS’);
END AFTER STATEMENT;

END mpa_compound_test;
/

– Getting an error:

ScreenShot044.jpeg

It seems like an unimplemented feature in SQLnav.

Hi Martin,

We planed to make compound trigger works in v7.1, SQLNAV-1211 has been raised for it already, once implemented will let you know.

Thanks,

Shirly

Hi Martin,

The compound trigger should work well in the latest beta now, please let us know if there is any problem with it, thanks.

www.toadworld.com/…/21862.aspx

Thanks,

Shirly

Not that I use them a lot but still…cool :wink: