Suggestion 1: Try having the trigger call a procedure. Put the update
code from the trigger in a procedure.
Suggestion 2:The mutating table error is a row-level trigger. The
solution is to use a statement level trigger and a row level trigger.
Use a PL/SQL table inside package to record
Good day all,
Have the following setup -
Oracle 8.1.7.2 on solaris
parent-child realtionship between 2 tables:
table p1 has primary key pk1
table f1 has foreign key p1pk1 back to table p1.
Table p1 also has a field haschild number(1), used to indicate if there
are ANY child records in table