Oracle Call Interface Programmer's Guide Release 2 (9.2) Part Number A96584-01 |
|
More OCI Relational Functions, 9 of 106
Sets piece information for a piecewise operation.
sword OCIStmtSetPieceInfo ( dvoid *hndlp, ub4 type, OCIError *errhp, CONST dvoid *bufp, ub4 *alenp, ub1 piece, CONST dvoid *indp, ub2 *rcodep );
The bind/define handle.
Type of the handle.
An error handle you can pass to OCIErrorGet()
for diagnostic information in the event of an error.
A pointer to a storage containing the data value or the piece when it is an IN bind variable, otherwise bufp
is a pointer to storage for getting a piece or a value for OUT binds and define variables. For named data types or REF
s, a pointer to the object or REF
is returned.
The length of the piece or the value.
The piece parameter. Valid values:
This parameter is used for IN bind variables only.
Indicator. A pointer to a sb2 value or pointer to an indicator structure for named data types (SQLT_NTY) and REF
s (SQLT_REF), that is, *indp
is either an sb2 or a dvoid * depending upon the data type.
Return code.
When an execute call returns OCI_NEED_DATA to get a dynamic IN/OUT bind value or piece, OCIStmtSetPieceInfo()
sets the piece information: the buffer, the length, which piece is currently being processed, the indicator, and the return code for this column.
See Also:
For more information about using |
OCIAttrGet(), OCIAttrSet(), OCIStmtExecute(), OCIStmtFetch(), OCIStmtGetPieceInfo()
This section describes the LOB functions.
Note the following for parameters in the OCI LOB calls:
CLOBs
and NCLOBs
, and in bytes for BLOBs
and BFILEs
.amtp
) parameter - When the amount parameter refers to the server-side LOB, the amount is in characters. When the amount parameter refers to the client-side buffer, the amount is in bytes. For more information, see individual LOB calls, such as OCILobGetLength()
, OCILobRead()
, and OCILobWrite()
.offset
) parameter - Regardless of whether the client-side character set is varying-width, the offset parameter is always in characters for CLOBs
and NCLOBs
and in bytes for BLOBs
and BFILEs
.CLOBs
and NCLOBs
. These LOB operations include OCILobCopy()
, OCILobErase()
, OCILobGetLength()
, OCILobLoadFromFile()
, and OCILobTrim()
. All these operations refer to the amount of LOB data on the server.A streaming operation means that the LOB is read or written in pieces. Streaming can be implemented using a polling mechanism or by registering a user-defined callback.
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|