The PIECEWISE member stored procedure sets the access mode for the current data value. If ANYDATA is of the TYPECODE_OBJECT type, setting the PIECEWISE mode causes each access to return the value of one attribute of the OBJECT type.
For collection elements, setting this mode causes each access to return one element from the collection. After this call, SET* and GET* are called sequentially to retrieve each attribute or collection element.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only 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
Before calling this procedure, the current data value must be of the OBJECT or COLLECTION type.
Segmented construction and access of nested attributes of objects or collections are not supported.