Home » SQL & PL/SQL » SQL & PL/SQL » How to overcome mutating table error.
How to overcome mutating table error. [message #218954] Mon, 12 February 2007 04:00 Go to next message
Messages: 1
Registered: February 2007
Junior Member

I am writing a trigger on a table.In that trigger i want to query the same table for checking the row which i am going to insert exists or not by takeing rowcount.

What is the solution for this?

Thanks in advance,
Nilesh Malekar
Re: How to overcome mutating table error. [message #219086 is a reply to message #218954] Mon, 12 February 2007 20:25 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Previous Topic: PLSQL Packages
Next Topic: Charaterset Converstion to UTF8
Goto Forum:

Current Time: Sun Oct 23 17:15:58 CDT 2016

Total time taken to generate the page: 0.09067 seconds