php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #6770 ora_numrows always returns 1
Submitted: 2000-09-15 07:27 UTC Modified: 2001-02-18 06:17 UTC
From: izzy at qumran dot org Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.1pl2 OS: SuSE 7.0
Private report: No CVE-ID: None
 [2000-09-15 07:27 UTC] izzy at qumran dot org
regardless of row count (if at least one row is there), ora_numrows returns 1 and not the correct number or affected rows. Syntax is put correctly (ora_numcols put into the same place returns the correct number, so it must be correct). We use Oracle 8.1.6 here.

default compile with just 3 params: --with-apxs=/usr/local/apache/bin/apxs --with-mysql=yes --with-oracle=/home/izzy/OraHome

nothing else special on the setup

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-09-15 07:33 UTC] izzy at qumran dot org
regardless of row count (if at least one row is there), ora_numrows returns 1 and not the correct number or affected rows. Syntax is put correctly (ora_numcols put into the same place returns the correct number, so it must be correct). We use Oracle 8.1.6 here.

default compile with just 3 params: --with-apxs=/usr/local/apache/bin/apxs --with-mysql=yes --with-oracle=/home/izzy/OraHome

nothing else special on the setup

btw: very similiar prob with ora_fetch_into just returning nothing, while ora_fetch works fine on the very same sql statement etc.
 [2000-09-16 23:19 UTC] sniper@php.net
Please use --with-oci8 instead of --with-oracle.

See http://www.php.net/manual/ref.oci8.php 
for more info.

--Jani
 [2000-09-23 00:03 UTC] izzy at qumran dot org
>Please use --with-oci8 instead of --with-oracle.

That doesn't solve my problem - the functions are still broken. I had to rewrite all our php apps that use, e.g., ora_logon to the oci8 functions (in this case: OCILogon). Otherwise I get returned "undefined function ora_logon" etc.pp.. Is there by any chance some possibility to get those functions (as named above) running correctly (or just working as expected ;) ?

Izzy.
 [2001-01-30 04:44 UTC] sniper@php.net
reclassified.

 [2001-02-18 06:17 UTC] thies@php.net
sadly oracle does not give that information.

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 21:01:27 2024 UTC