Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compound trigger problem

655128Mar 30 2009 — edited Mar 30 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2009
Added on Mar 30 2009
4 comments
489 views