mutating table

From: David Parkinson <dave_at_trueacid.freeserve.co.uk>
Date: 2000/04/22
Message-ID: <8dt7o2$9lb$1@newsg4.svr.pol.co.uk>#1/1

I have a table with a self relationship and I want to put a trigger on the table that checks the parent (on the same table) before allowing any update to the table. I can't do this because Oracle gives me a mutating table error for the trigger. Is there any way to get round this or do I have to scrap the idea?

I've thought of using a database procedure for the updates and taking update rights away from users but I would rather place the constraint (it's a constraint in the relational schema) in a trigger.

Can anybody help? Received on Sat Apr 22 2000 - 00:00:00 CDT