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

go to bug id or search bugs for

Bug #30214 OCIFetchInto works, oci_fetch_array, oci_fetch_row, etc. don't
Submitted: 2004-09-23 20:11 UTC Modified: 2005-04-02 01:00 UTC
From: errynp at gmail dot com Assigned: tony2001 (profile)
Status: No Feedback Package: OCI8 related
PHP Version: 5.0.1 OS: XP
Private report: No CVE-ID: None
View Developer Edit
 [2004-09-23 20:11 UTC] 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) = ""

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-10-06 18:44 UTC] 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-10-08 19:55 UTC] errynp at gmail dot com 
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.
 [2004-10-10 09:18 UTC] tony2001@php.net 
Could you plz run a script using oci_fetch_* in the console, using php.exe ?
Currently I've no possibility to test it with IIS, but all those functions work perfectly under Apache & Linux.
 [2004-10-18 01:00 UTC] php-bugs at lists dot php dot net 
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2004-10-18 18:07 UTC] errynp at gmail dot com 
By console, you're referring to a command-line run of the script in question?

In both cases, I get the page "dump". With oci_fetch* there is simply no data where it is expected. There are no warnings, errors, etc. of any kind.
 [2004-10-23 16:33 UTC] tony2001@php.net 
>In both cases, I get the page "dump".
 [2004-10-23 16:36 UTC] tony2001@php.net 
>In both cases, I get the page "dump".
i.e. source code? or no data?
 [2005-03-25 01:32 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip
 [2005-04-02 01:00 UTC] php-bugs at lists dot php dot net 
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2006-09-22 19:24 UTC] htran at med-eng dot com 
I am working with php 5 and i can't use oci_fetch_array and i always use OCIFetchInto.  I notice that I can't use any other underscore functions.
Do you know why?
Thanks much.
HT
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 15:01:29 2024 UTC