Talk:PLS INTEGER

Please consider to correct the following: PLS_INTEGER is an own datatype and not a subtype of INTEGER. Opposedly, INTEGER is a subtype of NUMBER, which means INTEGER is internally a NUMBER with a constraint on it.

Actually (since 8i) PLS_INTEGER is defined as a subtype of BINARY_INTEGER which is a subtype of INTEGER:

 subtype INTEGER is NUMBER(38,0);
 subtype BINARY_INTEGER is INTEGER range '-2147483647'..2147483647;
 subtype pls_integer is binary_integer;

Michel Cadot 16:09, 15 September 2011 (UTC)