Re: TRIGGER may not see it

  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_at_sferacarta.com>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_at_roughsea.com<mailto:
>> sfaroult_at_roughsea.com>> 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
>>
>>
> --
>
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l