Re: TRIGGER may not see it

From: jose soares <jose.soares_at_sferacarta.com>
Date: Mon, 14 Feb 2011 10:26:59 +0100
Message-ID: <4D58F563.5020501_at_sferacarta.com>

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

Received on Mon Feb 14 2011 - 03:26:59 CST