php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Request #31658 No way to move internal result pointer in OCI8 result set.
Submitted: 2005-01-22 21:41 UTC Modified: 2005-01-22 22:10 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:0 of 1 (0.0%)
From: jkcarter at uiuc dot edu Assigned:
Status: Wont fix Package: Feature/Change Request
PHP Version: 4.3.8 OS: Mac OS Server 10.3.7
Private report: No CVE-ID: None
View Developer Edit
 [2005-01-22 21:41 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-01-22 22:10 UTC] tony2001@php.net 
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.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Fri Jan 02 14:00:01 2026 UTC