Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLS_INTEGER limitations/issues ?
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
![]() |
![]() |