GETINFO Member Function

This function gets the type information for the AnyType.

Syntax

MEMBER FUNCTION GetInfo (
   self        IN AnyType,
   prec        OUT PLS_INTEGER, 
   scale       OUT PLS_INTEGER,
   len         OUT PLS_INTEGER, 
   csid        OUT PLS_INTEGER,
   csfrm       OUT PLS_INTEGER,
   schema_name OUT VARCHAR2, 
   type_name   OUT VARCHAR2, 
   version     OUT varchar2,
   count       OUT PLS_INTEGER)
   RETURN      PLS_INTEGER;

Parameters

Table 87-7 GETINFO Function Parameters

Parameter	Description
self	The AnyType.
prec, scale	If typecode represents a number. Gives precision and scale. Ignored otherwise.
len	If typecode represents a RAW, CHAR, VARCHAR, or VARCHAR2 type. Gives length.
csid, csfrm	If typecode represents a type requiring character information such as: CHAR, VARCHAR, VARCHAR2, CFILE.
schema_name, type_name, version	Type's schema (if persistent), typename and version.
count	If self is a VARRAY, this gives the VARRAY count. If self is of TYPECODE_OBJECT, this gives the number of attributes.

Returns

The typecode of self.

Exceptions

• DBMS_TYPES.invalid_parameters: Invalid Parameters (position is beyond bounds or the AnyType is not properly Constructed).