SET Member Procedures

Sets the current data value.

This is a list of procedures that should be called depending on the type of the current data value. The type of the data value should be the type of the attribute at the current position during the piece-wise construction process.

Syntax

MEMBER PROCEDURE SetNumber(
   self        IN OUT NOCOPY AnyData, 
   num         IN NUMBER,
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetDate(
   self        IN OUT NOCOPY AnyData, 
   dat         IN DATE,
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetChar(
   self        IN OUT NOCOPY AnyData, 
   c           IN CHAR,
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetVarchar(
   self        IN OUT NOCOPY AnyData, 
   c           IN VARCHAR,
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetVarchar2(
   self        IN OUT NOCOPY AnyData,
   c           IN VARCHAR2, 
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetRaw(
   self        IN OUT NOCOPY AnyData, 
   r           IN RAW,
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetBlob(
   self        IN OUT NOCOPY AnyData, 
   b           IN BLOB,
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetClob(
   self        IN OUT NOCOPY AnyData,
   c           IN CLOB,
   last_elem   IN boolean DEFAULT FALSE)'
MEMBER PROCEDURE SetBfile(
   self        IN OUT NOCOPY AnyData,
   b           IN BFILE,
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetObject(
   self        IN OUT NOCOPY AnyData,
   obj         IN "<object_type>",
   last_elem   IN boolean DEFAULT FALSE);
MEMBER PROCEDURE SetRef(
   self        IN OUT NOCOPY AnyData,
   rf          IN REF "<object_type>",
   last_elem   IN boolean DEFAULT FALSE),
MEMBER PROCEDURE SetCollection(
   self        IN OUT NOCOPY AnyData,
   col         IN "<collectyion_type>",
   last_elem   IN boolean DEFAULT FALSE);

Parameters

Table 85-4 SET*() Procedure Parameters

Parameter	Description
self	An AnyData.
num	The number, etc., that is to be set.
last_elem	Relevant only if AnyData represents a collection. Set to TRUE if it is the last element of the collection, FALSE otherwise.

Exceptions

• DBMS_TYPES.invalid_parameters: Invalid Parameters (if it is not appropriate to add a number at this point in the creation process).

• DBMS_TYPES.incorrect_usage: Incorrect usage.

• DBMS_TYPES.type_mismatch: When the expected type is different from the passed in type.

Usage Notes

When BeginCreate() is called, construction has already begun in a piece-wise fashion. Subsequent calls to Set*() will set the successive attribute values.

If the AnyData is a standalone collection, the Set*() call will set the successive collection elements.