#31658 [Opn->WFx]: No way to move internal result pointer in OCI8 result set.

ID: 31658 Updated by: tony2001@php.net Reported By: jkcarter at uiuc dot edu -Status: Open +Status: Wont fix Bug Type: Feature/Change Request Operating System: Mac OS Server 10.3.7 PHP Version: 4.3.8 New Comment: libmysql stores data on the client side and that makes possible to move through the result. OCI doesn't provide such possibility just because the data is transferred to the client when you call OCIFetch() function (though, you can use oci_set_prefetch() to prefetch them). OCI provides different way to handle such things called "scrollable cursors". But they have their own limitations & overheads and ATM I don't think that OCI8 module will support them until someone offer a stable solution. Previous Comments: ------------------------------------------------------------------------ [2005-01-22 21:41:50] jkcarter at uiuc dot edu Description: ------------ There is no way to alter the position of an OCI8 internal result pointer. For example, suppose one wants to print the first three rows of a result set multiple times. In MySQL, you have the mysql_data_seek($rs,0) function to move the result pointer back to the first row. In OCI8, there is no analagous function. Please add this function. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=31658&edit=1