Toad World® Forums

SQLnav cannot create COMPOUND triggers?


#1

– 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.


#2

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


#3

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


#4

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