Re: ORA-4091: Mutating Tables...

Refer to page 8-9 of the "Application Developer's Guide".

"A mutatiing table is a table that iis currently being modifed by an UPDATE,
DELETE, or INSERT statement...."

then later...

"o The statements of a row trigger cannot read from or modify a mutating table
of the triggering statement..."

You say that the trigger calls a procedure which tries to read the same table that the trigger is defined on. This is reading the mutating table, which is not allowed.

Aside,
The status column in the master table is not dependant upon the primary key of the master table. Your data model is not in normal form.

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, Senior CASE Support Consultant
Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+