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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: jkcarter at uiuc dot edu
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Mon Jul 01 10:01:29 2024 UTC