The GET* member function is used to retrieve the current data value, which matches the type of the calling function.
The type of the current data value depends on the current access mode of ANYDATA. This includes whether PIECEWISE has been called.
If PIECEWISE has not been called, the entire ANYDATA data is accessed, and the data value's type should match the type of ANYDATA.
If PIECEWISE has been called, ANYDATA is accessed in segments. The data value's type should match the type of the current attribute (or collection element).
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition only provides MySQL mode.
Syntax
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 GetObject(
self IN AnyData,
obj OUT NOCOPY "<ADT_1>")
RETURN PLS_INTEGER;
MEMBER FUNCTION GetCollection(
self IN AnyData,
col OUT NOCOPY "<COLLECTION_1>")
RETURN PLS_INTEGER;
MEMBER FUNCTION GetTimestamp(
self IN AnyData,
ts OUT NOCOPY TIMESTAMP_UNCONSTRAINED)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetTimestampTZ(
self IN AnyData,
ts OUT NOCOPY TIMESTAMP_TZ_UNCONSTRAINED)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetTimestampLTZ(
self IN AnyData,
ts OUT NOCOPY TIMESTAMP_LTZ_UNCONSTRAINED)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetIntervalYM(
self IN AnyData,
inv IN OUT NOCOPY YMINTERVAL_UNCONSTRAINED)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetIntervalDS(
self IN AnyData,
inv IN OUT NOCOPY DSINTERVAL_UNCONSTRAINED)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetNchar(
self IN AnyData,
nc OUT NOCOPY NCHAR)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetNVarchar2(
self IN AnyData,
nc OUT NOCOPY NVARCHAR2)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetBFloat(
self IN AnyData,
fl OUT NOCOPY BINARY_FLOAT)
RETURN PLS_INTEGER;
MEMBER FUNCTION GetBDouble(
self IN AnyData,
dbl OUT NOCOPY BINARY_DOUBLE)
RETURN PLS_INTEGER;
Parameters
| Parameter | Description |
|---|---|
| self | An ANYDATA object. |
| num | The numeric value to retrieve. |
Return value
The return value varies depending on the access mode. In PIECEWISE mode (used for collections), DBMS_TYPES.NO_DATA indicates the end of collection access.
Exceptions
DBMS_TYPES.TYPE_MISMATCH: The expected type does not match the provided type.DBMS_TYPES.INVALID_PARAMETERS: Invalid parameters (if a numeric value cannot be added at the current stage of the procedure).DBMS_TYPES.INCORRECT_USAGE: Incorrect usage.