oci_set_prefetch

PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0
oci_set_prefetch - Sets number of rows to be prefetched by queries
Manual
Code Examples

Example #1 Setting the prefetch value when passing a REF CURSOR back to Oracle

means only fetch one row at a time.

Edit/Test in Sandbox
PHP Version:

Example #2 Changing the default prefetch value for a query

Edit/Test in Sandbox
PHP Version:

Example #3 Changing the default prefetch for a REF CURSOR fetch

Edit/Test in Sandbox
PHP Version:


Function oci_set_prefetch:

Oracle OCI8 Functions

Most used PHP functions