OCIStmtFetch2 and OCI_ATTR_PREFETCH_ROWS

 Hello, 

"Precompilers and OCI" is the only community's title that has "OCI" keyword in it so I think I should post my question here.

Looking at the doc and the comments in the ociap.h file, it is not clear to me that using OCI_ATTR_PREFETCH_ROWS will have precedence over nrows in OCIStmtFetch2 calls for SELECT statements.

sword OCIStmtFetch2 ( OCIStmt     *stmtp,

                   OCIError    *errhp, 

                   ub4         nrows,

                   ub2         orientation,

                   ub4         scrollOffset,

                   ub4         mode);

Apart from the OCIStmtExecute that will already fetch "iters" rows ( right ?), 

will I get 2 rows (I understood it is already defaulting to 1 row + 1 prefetch) or 100 rows if I am in the following case for a SELECT statement :