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

Home -> Community -> Usenet -> c.d.o.server -> pls_integer datatype.

pls_integer datatype.

From: Daz <none_at_hotmail.com>
Date: Sat, 26 Oct 2002 10:49:32 +0000 (UTC)
Message-ID: <unrkru4cr2g5dq2rgidpnuqkt94vjg9itv@4ax.com>


Hi,

when doing stuff like:

select count(x)
  into variable
  from table;

i usually define the variable type as just plain ol integer.. will changing that to pls_integer cause any implicit datatype conversions to be done in the into, and thus should it be avoided?

the same goes for procs/functions returning integers or binary_integers .. does assigning them to a pls_integer do an implicit conversion ?

thanks.

Daz.

using Oracle 8.1.7.2 Received on Sat Oct 26 2002 - 05:49:32 CDT

Original text of this message

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