Re: Improving performance of calculations in PL/SQL

From: Charlie Edwards <charlie3101_at_hotmail.com>
Date: 28 Jan 2004 02:31:43 -0800
Message-ID: <217ac5a8.0401280231.55d1cb75@posting.google.com>

John Russell <netnews8_at_johnrussell.mailshell.com> wrote in message news:<rdke1096viruus3gt3eq4qkp5rv262trbd_at_4ax.com>...
> On 27 Jan 2004 02:06:37 -0800, charlie3101_at_hotmail.com (Charlie
> Edwards) wrote:
> >Thanks for those suggestions. I've already done a lot of that, but I
> >didn't know about the performance issue with using pls_integer for
> >integer variable.
>
> Also use INDEX BY PLS_INTEGER rather than INDEX BY BINARY_INTEGER.
>
> John

FYI LINE/COL ERROR

-------- -----------------------------------------------------------------
2/4      PL/SQL: Declaration ignored
2/27     PLS-00315: PL/SQL TABLE declarations must currently use
         binary_integer indexes

I assume it's new to 9i

CE Received on Wed Jan 28 2004 - 04:31:43 CST