Re: Dreaded PLS-123 Error
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: post.ethan@xxxxxxxxx
- Date: Thu, 16 Nov 2006 11:02:39 -0800
On 11/16/06, Jared Still <jkstill@xxxxxxxxx> wrote:
On 11/9/06, Ethan Post <post.ethan@xxxxxxxxx> 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
Other related posts:
