note 43941 deleted from function.oci-fetch-all by sixd
| From: | sixd@php.net | Date: | Fri, 20 Nov 2009 23:30:36 +0000 |
| Subject: | note 43941 deleted from function.oci-fetch-all by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163148@lists.php.net to get a copy of this message | ||
Note Submitter: humberto at humbertosilva dot com
----
I had a problem with ocifetchstatement, it didn't returned nor more or less than 13 rows
whatever the skip or num_rows was set to....
I found that it has a bug, you MUST specify the last parameter, so i added OCI_FETCHSTATEMENT_BY_ROW
to the function call and it works fine.
Hope this helps someone out there ...
With:
$rows=ocifetchstatement ($st, &$arr, 0, 20);
Returns:
$rows � 20
count($arr) � 13 !!! (should be 20)
Now here's the working version:
With:
$rows=ocifetchstatement ($st, &$arr, 0, 20, OCI_FETCHSTATEMENT_BY_ROW);
Returns:
$rows � 20
count($arr) � 20
wich are the right values.
Regards,
Humberto Silva
http://www.humbertosilva.com/