The PIECEWISE member procedure sets the mode of access to the current data value. If the ANYDATA is of the TYPECODE_OBJECT type, an attribute value of an OBJECT type is returned for each access after you use PIECEWISE to set the access mode.
For collection elements, an element in the collection is returned for each access after you set the access mode. Once this call has been made, subsequent calls to SET* and GET* will sequentially obtain individual attributes or collection elements.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
MEMBER PROCEDURE PieceWise(
self IN OUT NOCOPY AnyData);
Parameters
| Parameter | Description |
|---|---|
| self | An ANYDATA. |
Exceptions
DBMS_TYPES.INVALID_PARAMETERS: Invalid parameters.DBMS_TYPES.INCORRECT_USAGE: Incorrect usage.
Considerations
The current data value must be of an OBJECT or COLLECTION type before this call is made.
Piece-wise construction of and access to nested attributes that are of OBJECT or COLLECTION types are not supported.