The PIECEWISE member stored procedure specifies the access mode for the current data value. If ANYDATA is of the TYPECODE_OBJECT type, after you set the PIECEWISE mode, each access returns the value of an attribute of the OBJECT type.
For a collection element, after you set this mode, each access returns an element of the collection. After this call, the SET* and GET* procedures are sequentially called to obtain the attributes or collection elements.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
MEMBER PROCEDURE PieceWise(
self IN OUT NOCOPY AnyData);
Parameters
| Parameter | Description |
|---|---|
| self | An ANYDATA object. |
Exceptions
DBMS_TYPES.INVALID_PARAMETERS: Invalid parameter.DBMS_TYPES.INCORRECT_USAGE: Incorrect usage.
Considerations
Before you call this procedure, the current data value must be of the OBJECT or COLLECTION type.
You cannot construct and access nested attributes of an object or collection in piecewise mode.