ADDATTR Member Procedure

This procedure adds an attribute to an AnyType (of typecode DBMS_TYPES.TYPECODE_OBJECT).

Syntax

MEMBER PROCEDURE AddAttr(
   self          IN OUT NOCOPY AnyType,
   aname         IN VARCHAR2,
   typecode      IN PLS_INTEGER,
   prec          IN PLS_INTEGER,
   scale         IN PLS_INTEGER,
   len           IN PLS_INTEGER,
   csid          IN PLS_INTEGER,
   csfrm         IN PLS_INTEGER,
   attr_type     IN ANYTYPE DEFAULT NULL);

Parameters

Table 87-4 ADDATTR Procedure Parameters

Parameter	Description
self	The transient AnyType that is being constructed. Must be of type DBMS_TYPES.TYPECODE_OBJECT.
aname (OPTIONAL)	Attribute's name. Could be NULL.
typecode	Attribute's typecode. Can be built-in or user-defined typecode (from DBMS_TYPES package).
prec, scale (OPTIONAL)	Required if typecode represents a NUMBER. Give precision and scale. Ignored otherwise.
len (OPTIONAL)	Required if typecode represents a RAW, CHAR, VARCHAR, or VARCHAR2 type. Give length.
csid, csfrm (OPTIONAL)	Required if typecode represents a type requiring character information, such as CHAR, VARCHAR, VARCHAR2, CFILE.
attr_type (OPTIONAL)	AnyType corresponding to a user-defined type. This parameter is required if the attribute is a user defined type.

Exceptions

• DBMS_TYPES.invalid_parameters: Invalid Parameters (typecode, typeinfo)

• DBMS_TYPES.incorrect_usage: Incorrect usage (cannot call after calling EndCreate(), etc.)