Re: [Q] Database Trigger mutating error...
From: Robert Pereira <robert_at_bytesize.ftech.co.uk>
Date: 1995/08/06
Message-ID: <403ek8$8ln_at_mars.ftech.co.uk>#1/1
Date: 1995/08/06
Message-ID: <403ek8$8ln_at_mars.ftech.co.uk>#1/1
Ah, the old Mutant Trigger problem
Oracle blocked developers from referencing the same table
that you were creating a trigger on. Otherwise you could
write code which ends up in an infinate loop.
Solution - Stored Procedures. Write a proc to perform the same
function and remove the UPDATE etc privs from the DB Role/User
and grant EXECUTE priv on the proc to the DB Roler/user instead.
OK?
Robert
Received on Sun Aug 06 1995 - 00:00:00 CEST