Table E-3 lists the deprecated Statement functions that are described in this section.
Fetch rows from a query.
Fetches rows from a query. This function is deprecated. Use OCIStmtFetch2().
sword OCIStmtFetch ( OCIStmt *stmtp, OCIError *errhp, ub4 nrows, ub2 orientation, ub4 mode );
A statement (application request) handle.
An error handle that you can pass to OCIErrorGet() for diagnostic information when there is an error.
Number of rows to be fetched from the current position.
Before release 9.0, the only acceptable value is
OCI_FETCH_NEXT, which is also the default value.
The fetch call is a local call, if prefetched rows suffice. However, this is transparent to the application.
If LOB columns are being read, LOB locators are fetched for subsequent LOB operations to be performed on these locators. Prefetching is turned off if
LONG columns are involved.
This function can return
OCI_SUCCESS_WITH_INFO when one of these errors occurs:
ORA-24344 - Success with compilation error
ORA-24345 - A truncation or
NULL fetch error occurred
ORA-24347 - Warning of a
NULL column in an aggregate function
If you call
OCIStmtFetch() with the
nrows parameter set to 0, this cancels the cursor.
OCI_ATTR_ROWS_FETCHED to find the number of rows that were successfully fetched into the user's buffers in the last fetch call.