No, this will not work, you will still get the "mutating table" error.


-----Original Message-----
From: v [mailto:v.[Email address protected]
Sent: 31 May 2005 10:57
To: Cardus, Ian
Subject: RE: Triggers problem


Yes you are correct . mutating is problem ..

now to overcome this what i am doing is

i am creating a temporary table in which i will store the action

so on my table vijay trigger V_INSERT_TRIGGER

i will write insert into temp_v values (id_v , 'I',sysdate);

and on temp_v i will write a trigger on insert

will do what i wanted to do

will that work

or still it will consider it as one transaction and give mutation error

Regards

Vijay Shah
Software Developer




*****************************************************************************
This e-mail and its attachments are confidential and are intended for the above named recipient only. If this has come to you in error, please notify the sender immediately and delete this e-mail from your system. You must take no action based on this, nor must you copy or disclose it or any part of its contents to any person or organisation. Statements and opinions contained in this email may not necessarily represent those of Littlewoods Group Limited or its subsidiaries. Please note that e-mail communications may be monitored. The Registered Office of Littlewoods Group Limited and its subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB. Registered number of Littlewoods Group Limited is 5059352.
*****************************************************************************




This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com

Oracle LazyDBA home page