|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #907 ora_fetch_into returns a too short row if last fields are empty
Submitted: 1998-11-09 05:13 UTC Modified: 1999-05-29 11:43 UTC
From: eb at gifrance dot com Assigned:
Status: Closed Package: Oracle related
PHP Version: 3.0.5 OS: Solaris 2.5.1
Private report: No CVE-ID: None
 [1998-11-09 05:13 UTC] eb at gifrance dot com
$query = "SELECT nom_classif, desc_classif, img_classif FROM classifications WHERE num_classif=6";

In this case, nom_classif = "Mode", desc_classif=img_classif="";

ora_fetch_into returns array("Mode") instead of array("Mode", "", "")

This occurs only when the last records are empty (in this case, desc_classif and img_classif).

I use PHP module with Netscape Server 3.5.1 and Oracle 7.3.4.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [1999-05-29 11:29 UTC] thies at cvs dot php dot net
please do
ora_fetch_into($curs,&$arr,ORA_FETCHINTO_NULLS) to also get NULL columns returned!

 [1999-05-29 11:43 UTC] thies at cvs dot php dot net
forgot to change the state
 [2003-12-02 07:07 UTC] arulvel dot ramanan at citigroup dot com
When we are compiling PL/SQL PLLs(Forms version 6) in ORACLE UNIX (HP-UX-9i) environment. We are getting the above error as follows.

ERROR 907 at line 1, column 1
cannot load library unit PUBLIC.TPACKAGE (referenced by ABC)

But finally it is ended with "Done. abc.pll compiled"

Is it ok to ignore the same and use the generated plx. Or whether there will be any issues in future. Is there anyway to compile plls and fmbs without the above issue.

PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sat Sep 25 22:03:39 2021 UTC