note 86834 added to function.oci-new-cursor

Because OCI8 uses "prefetching" to greatly improve returning query results, but Oracle doesn't support prefetching for REF CURSORs, application performance using REF CURSORs can be greatly improved by writing a PL/SQL function that pulls data from the REF CURSOR and PIPEs the output. The new function can be queried in a SELECT as if it were a table. See http://blogs.oracle.com/opal/2008/11/ converting_ref_cursor_to_pipe.html ---- Server IP: 64.71.164.2 Probable Submitter: 148.87.1.172 ---- Manual Page -- http://www.php.net/manual/en/function.oci-new-cursor.php Edit -- https://master.php.net/note/edit/86834 Del: integrated -- https://master.php.net/note/delete/86834/integrated Del: useless -- https://master.php.net/note/delete/86834/useless Del: bad code -- https://master.php.net/note/delete/86834/bad+code Del: spam -- https://master.php.net/note/delete/86834/spam Del: non-english -- https://master.php.net/note/delete/86834/non-english Del: in docs -- https://master.php.net/note/delete/86834/in+docs Del: other reasons-- https://master.php.net/note/delete/86834 Reject -- https://master.php.net/note/reject/86834 Search -- https://master.php.net/manage/user-notes.php