– 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:
It seems like an unimplemented feature in SQLnav.