ODPI-C Enumeration dpiFetchModeΒΆ

This enumeration identifies the mode to use when scrolling the cursor to a new location using the function dpiStmt_scroll().

Value Description
DPI_MODE_FETCH_NEXT Scroll the cursor to the next row in the result set. The offset is ignored when using this mode.
DPI_MODE_FETCH_FIRST Scroll the cursor to the first row in the result set. The offset is ignored when using this mode.
DPI_MODE_FETCH_LAST Scroll the cursor to the last row in the result set. The offset is ignored when using this mode.
DPI_MODE_FETCH_PRIOR Scroll the cursor to the previous row in the result set. The offset is ignored when using this mode.
DPI_MODE_FETCH_ABSOLUTE Scroll the cursor to the row identified by the offset parameter using absolute positioning.
DPI_MODE_FETCH_RELATIVE Scroll the cursor to the row identified by the offset parameter using relative positioning. A positive number will move forward in the result set while a negative number will move backwards in the result set.