Re: Dreaded PLS-123 Error

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 16 Nov 2006 11:01:43 -0800
Message-ID: <bf46380611161101o4dea99bbo6db9d5a25bf7073d@mail.gmail.com>

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.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Thu Nov 16 2006 - 13:01:43 CST