From Oracle FAQ
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)