Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
ANYDATASET TYPE, 10 of 11
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.
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;
Parameter | Description |
---|---|
self |
The AnyDataSet being accessed. |
num |
The number, etc., that is to be obtained. |
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.
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.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|