Compound trigger problem
655128Mar 30 2009 — edited Mar 30 2009Hi,
In order to avoid mutating tables error, i am having to use compound triggers. Here is the sql for creating the triggers that i use:
SQL> CREATE OR REPLACE TRIGGER abc
FOR DELETE ON emp_table
COMPOUND TRIGGER
AFTER EACH ROW IS
BEGIN
pkg_name.on_delete_trg(:OLD.EMP_ID);
END AFTER EACH ROW;
END abc;
Now after executing this, i get this error:
LINE/COL ERROR
-------- -----------------------------------------------------------------
6/16 PLS-00103: Encountered the symbol "." when expecting one of the
following:
;
Does this mean i cannot call a procedure in another package from the body of a compound trigger?
thanks