note 93924 added to function.oci-set-prefetch

With Oracle 11gR2, prefetching also works when fetching from REF CURSORS and nested queries. To use a non default prefetch count, use oci_set_prefetch. For example, on the REF CURSOR statement handle: $stid = oci_parse($c, "call myproc(:rc)"); $refcur = oci_new_cursor($c); oci_bind_by_name($stid, ':rc', $refcur, -1, OCI_B_CURSOR); oci_execute($stid); oci_set_prefetch($refcur, 200); oci_execute($refcur); oci_fetch_all($refcur, $res); var_dump($res); REF CURSOR prefetching can be used when PHP is linked with Oracle 11gR2 libraries and connected to previous database versions of the database. Nested cursor prefetching requires both the Oracle client libraries linked with PHP and the database to be Oracle Database 11gR2 From PHP 5.3.2 (PHP OCI8 >= 1.4) the prefetch value may be set to 0. Previously the lower bound was 1. If PHP OCI8 fetches from a REF CURSOR and then passes the REF CURSOR back to a second PL/SQL procedure for further processing, set the REF CURSOR prefetch count to 0 to avoid rows being "lost" from the result set. // get the REF CURSOR $stid = oci_parse($c, "call myproc_get_rc(:rc_out)"); $refcur = oci_new_cursor($c); oci_bind_by_name($stid, ':rc_out', $refcur, -1, OCI_B_CURSOR); oci_execute($stid); // Fetch one row and display it oci_set_prefetch($refcur, 0); // don't prefetch rows that aren't displayed oci_execute($refcur); $row = oci_fetch_array($refcur); var_dump($res); // pass the REF CURSOR to myproc_use_rc() to do more data processing $stid = oci_parse($c, "call myproc_use_rc(:rc_in)"); oci_bind_by_name($s ---- Server IP: 69.147.83.197 Probable Submitter: 148.87.1.172 ---- Manual Page -- http://www.php.net/manual/en/function.oci-set-prefetch.php Edit -- https://master.php.net/note/edit/93924 Del: integrated -- https://master.php.net/note/delete/93924/integrated Del: useless -- https://master.php.net/note/delete/93924/useless Del: bad code -- https://master.php.net/note/delete/93924/bad+code Del: spam -- https://master.php.net/note/delete/93924/spam Del: non-english -- https://master.php.net/note/delete/93924/non-english Del: in docs -- https://master.php.net/note/delete/93924/in+docs Del: other reasons-- https://master.php.net/note/delete/93924 Reject -- https://master.php.net/note/reject/93924 Search -- https://master.php.net/manage/user-notes.php