Re: TRIGGER may not see it
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: jose.soares@xxxxxxxxxxxxxx
- Date: Mon, 14 Feb 2011 10:37:51 -0800
Try:
5 FOR EACH ROW
6 declare
7 pragma autonomous_transaction;
8 begin
But understand what it does before you use it.
Mike
On Mon, Feb 14, 2011 at 1:26 AM, jose soares <jose.soares@xxxxxxxxxxxxxx>wrote:
> Thanks to everybody who replyed to my message.
> I see there are many things that I have to learn yet about triggers,
> thanks for tips and links, I'm reading
>
> http://download.oracle.com/docs/cd/E11882_01/appdev.112/e17126/triggers.htm#LNPLS743
> to deepen my knowledge about triggers.
>
> j
>
>
>
> Jared Still wrote:
>
> On Fri, Feb 11, 2011 at 5:48 AM, Stephane Faroult
> <sfaroult@xxxxxxxxxxxx<mailto:
>> sfaroult@xxxxxxxxxxxx>> wrote:
>>
>> You may find this useful:
>>
>>
>> http://asktom.oracle.com/pls/asktom/ASKTOM.download_file?p_file=6551198119097816936
>>
>>
>> I've used that method in a paper/presentation on normalization.
>>
>> Why do you need the workaround in Kyte's article?
>>
>> Because you are working with poorly designed database,
>> as I am sure you already know. :)
>>
>> This was the point in my presentation - if you are trying to work around
>> mutating table errors, you should revisit the design if possible.
>>
>> While the workaround for mutating tables does work, it is very convoluted.
>> In your case Stephane, I know I am preaching
>> to the choir, but there are lots of other readers here. :)
>>
>> Jared Still
>> Certifiable Oracle DBA and Part Time Perl Evangelist
>> Oracle Blog: http://jkstill.blogspot.com
>> Home Page: http://jaredstill.com
>>
>>
> --
>
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
