setPrefetchRows method

Future<void> setPrefetchRows(
  1. int numRows
)

Set prefetch rows

Sets the number of rows to prefetch. Prefetching can significantly improve performance for queries that return many rows.

Implementation

Future<void> setPrefetchRows(int numRows) async {
  if (_disposed) {
    throw OracleStatementException('Statement has been closed', sql: _sql);
  }

  final result = _dpiOracle.dpiStmt_setPrefetchRows(
    _statementPtr.value,
    numRows,
  );

  if (result == DPI_FAILURE) {
    throw OracleStatementException(
      'Failed to set prefetch rows',
      sql: _sql,
    );
  }
}