GET* Member Functions

These functions get the current data value (which should be of appropriate type).

The type of the current data value depends on the MODE with which you are accessing it (depending on how we have invoked the PieceWise() call). If PieceWise() has NOT been called, we are accessing the instance in its entirety and the type of the data value should match the type of the AnyDataSet.

If PieceWise() has been called, we are accessing the instance piece-wise. The type of the data value should match the type of the attribute (or collection element) at the current position.

Syntax

MEMBER FUNCTION GetNumber(
   self        IN AnyDataSet,
   num         OUT NOCOPY NUMBER)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetDate(
   self        IN AnyDataSet,
   dat         OUT NOCOPY DATE)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetChar(
   self        IN AnyDataSet,
   c           OUT NOCOPY CHAR)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetVarchar(
   self        IN AnyDataSet,
   c           OUT NOCOPY VARCHAR)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetVarchar2(
   self        IN AnyDataSet,
   c           OUT NOCOPY VARCHAR2)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetRaw(
   self        IN AnyDataSet,
   r           OUT NOCOPY RAW)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetBlob(
   self        IN AnyDataSet,
   b           OUT NOCOPY BLOB)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetClob(
   self        IN AnyDataSet,
   c           OUT NOCOPY CLOB)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetBfile(
   self        IN AnyDataSet,
   b           OUT NOCOPY BFILE)
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetObject(
   self        IN AnyDataSet,
   obj         OUT NOCOPY "<object_type>")
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetRef(
   self        IN AnyDataSet,
   rf          OUT NOCOPY REF "<object_type>")
   RETURN      PLS_INTEGER;
MEMBER FUNCTION GetCollection(
   self        IN AnyDataSet,
   col         OUT NOCOPY "<collection_type>") 
   RETURN      PLS_INTEGER;

Parameters

Table 86-10 GET* Procedure Parameters

Parameter	Description
self	The AnyDataSet being accessed.
num	The number, etc., that is to be obtained.

Returns

DBMS_TYPES.SUCCESS or DBMS_TYPES.NO_DATA

The return value is relevant only if PieceWise() has been already called (for a collection). In such a case, DBMS_TYPES.NO_DATA signifies the end of the collection when all elements have been accessed.

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.