On 11/16/06, Jared Still <jkstill_at_gmail.com> wrote:
>
> On 11/9/06, Ethan Post <post.ethan_at_gmail.com> wrote:
> >
> > Thanks, we can not do that because it is not that much variety of code,
> > just a column by column check for changing values which then goes to audit
> > log table if value is changing. However, that is good to know, I was not
> > aware that the limits were different.
>
>
> Why not?
>
> Create index-by table in the trigger, populate it with new/old values,
> send the index-by table as a parameter to the package.
>
Actually, create the index-by table in the package header, and
then just reference it in the trigger.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 16 2006 - 13:02:39 CST
