Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
ANYDATA TYPE, 8 of 8
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 we are accessing (depending on whether we have invoked the PieceWise()
call).
If PieceWise()
has NOT been called, we are accessing the AnyData in its entirety and the type of the data value should match the type of the AnyData.
If PieceWise()
has been called, we are accessing the AnyData 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 AnyData, num OUT NOCOPY NUMBER) RETURN PLS_INTEGER; MEMBER FUNCTION GetDate( self IN AnyData, dat OUT NOCOPY DATE) RETURN PLS_INTEGER; MEMBER FUNCTION GetChar( self IN AnyData, c OUT NOCOPY CHAR) RETURN PLS_INTEGER; MEMBER FUNCTION GetVarchar( self IN AnyData, c OUT NOCOPY VARCHAR) RETURN PLS_INTEGER; MEMBER FUNCTION GetVarchar2( self IN AnyData, c OUT NOCOPY VARCHAR2) RETURN PLS_INTEGER; MEMBER FUNCTION GetRaw( self IN AnyData, r OUT NOCOPY RAW) RETURN PLS_INTEGER; MEMBER FUNCTION GetBlob( self IN AnyData, b OUT NOCOPY BLOB) RETURN PLS_INTEGER; MEMBER FUNCTION GetClob( self IN AnyData, c OUT NOCOPY CLOB) RETURN PLS_INTEGER; MEMBER FUNCTION GetBfile( self IN AnyData, b OUT NOCOPY BFILE) RETURN PLS_INTEGER; MEMBER FUNCTION GetObject( self IN AnyData, obj OUT NOCOPY "<object_type>") RETURN PLS_INTEGER; MEMBER FUNCTION GetRef( self IN AnyData, rf OUT NOCOPY REF "<object_type>") RETURN PLS_INTEGER; MEMBER FUNCTION GetCollection( self IN AnyData, col OUT NOCOPY "<collection_type>") RETURN PLS_INTEGER;
Parameter | Description |
---|---|
self |
An AnyData. |
num |
The number, etc., 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.type_mismatch: When the expected type is different from the passed in type.
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.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|