GETATTRELEMINFO Member Function

This function gets the type information for an attribute of the type (if it is of TYPECODE_OBJECT). Gets the type information for a collection's element type if the self parameter is of a collection type.

Syntax

MEMBER FUNCTION GetAttrElemInfo (
   self           IN AnyType, 
   pos            IN PLS_INTEGER,
   prec           OUT PLS_INTEGER, 
   scale          OUT PLS_INTEGER,
   len            OUT PLS_INTEGER, 
   csid           OUT PLS_INTEGER, 
   csfrm          OUT PLS_INTEGER,
   attr_elt_type  OUT ANYTYPE
   aname          OUT VARRCHAR2)
   RETURN         PLS_INTEGER;

Parameters

Table 87-8 GETATTRELEMINFO Function Parameters

Parameter	Description
self	The AnyType.
pos	If self is of TYPECODE_OBJECT, this gives the attribute position (starting at 1). It is ignored otherwise.
prec, scale	If attribute/collection element 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. Gives character set ID, character set form.
attr_elt_type	IF attribute/collection element typecode represents a user-defined type, this returns the AnyType corresponding to it. User can subsequently describe the attr_elt_type.
aname	Attribute name (if it is an attribute of an object type, NULL otherwise).

Returns

The typecode of the attribute or collection element.

Exceptions

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