Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLS_INTEGER limitations/issues ?

Re: PLS_INTEGER limitations/issues ?

From: Roel <verbunroX_at_Xiquip.nl>
Date: Wed, 15 Dec 1999 00:13:49 GMT
Message-ID: <3856dcb3.8026608@news.euro.net>

PLS_INTEGER is no longer supported in Forms 6.0. When upgrading our 4.5 forms I had to change all these variables to NUMBER.

Roel

On Tue, 14 Dec 1999 07:52:29 GMT, pbolduc_at_my-deja.com wrote:

>
>
>I know using PLS_INTEGER data types can make loop counters about 3x
>quicker than using NUMBER data type, however, the Oracle docs are not
>very clear on the limitations of using PLS_INTEGER data type. What are
>the limitations/issues involved besides the obvious one of same
>limitations as a long int in C. (integer only, max value around 2^31).
>Is there overhead in passing PLS_INTEGER to PL/SQL functions such as
>SUBSTR or MOD.
>
>Are there any other issues one should be aware of?
>
>Phil Bolduc
>North Vancouver, Canada
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Dec 14 1999 - 18:13:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US