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
nmalekar
Messages: 1
Registered: February 2007
Junior Member
Hi,

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
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
./fa/456/0/
Previous Topic: PLSQL Packages
Next Topic: Charaterset Converstion to UTF8
Goto Forum:
  


Current Time: Sun Dec 04 20:27:25 CST 2016

Total time taken to generate the page: 0.28077 seconds