ID: 30214
User updated by: errynp at gmail dot com
Reported By: errynp at gmail dot com
-Status: Feedback
+Status: Open
Bug Type: Oracle related
Operating System: XP
PHP Version: 5.0.1
New Comment:
Windows 2K Server, Oracle 9i, using IIS.
As for how to reproduce it, create a connection to any Oracle database
and try to execute any SQL statement that returns records. OCIFetchInto
is the only function that actually returns a dataset. OCIFetchInto and
the various oci_fetch replacements should be largely interchangeable,
but oci_fetch_* seems to return no data at all. At least, this is the
case here.
Previous Comments:
------------------------------------------------------------------------
[2004-10-06 18:44:26] tony2001@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
How can we reproduce it? What's your OS, Apache version, Oracle
version?
------------------------------------------------------------------------
[2004-09-23 20:11:38] errynp at gmail dot com
Description:
------------
Using an abstraction layer, a row was being fetched with OCIFetchInto,
which works. Switching to one of the other functions returns nothing.
Reproduce code:
---------------
$result =
OCIFetchInto($query_id,$result_row,OCI_ASSOC+OCI_RETURN_NULLS); //
returns data
None of these replacements return data:
$result = oci_fetch_assoc($query_id);
$result = oci_fetch_row($query_id);
$result = oci_fetch_array($query_id,OCI_ASSOC+OCI_RETURN_NULLS);
$result = oci_fetch_object($query_id);
Expected result:
----------------
The same data that the same SQL and connection returns with
OCIFetchInto.
Actual result:
--------------
vardump says string(0) = ""
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=30214&edit=1