PLS_INTEGER limitations/issues ?

From: <pbolduc_at_my-deja.com>
Date: Tue, 14 Dec 1999 07:52:29 GMT
Message-ID: <834svt$jhf$1@nnrp1.deja.com>

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 - 01:52:29 CST