Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need workaround for Oracle Mutating table

Re: Need workaround for Oracle Mutating table

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 23 Jan 2007 09:30:25 -0800
Message-ID: <1169573420.570047@bubbleator.drizzle.com>


hasta_l3_at_hotmail.com wrote:
> swapnil.kale_at_gmail.com a écrit :

>> Thanks DA Morgan. It solved the problem. Thanks a lot for the help. I
>> referred the "Autonomous Transaction" and thats what i needed. <I'll
>> definately think over remodelling it.>
>>
>> Regards,
>> Swapnil

>
> Swapnil, it is rare that an autonomous transaction is a
> solution to the mutating table warning...
>
> Could we see your solution ?
>
> --- Raoul

You can find one example at:
http://www.psoug.org/reference/table_trigger.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Jan 23 2007 - 11:30:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US