php.net |  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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

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
Hi,
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.

regards
Arulvel
 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Mon Nov 30 12:01:23 2020 UTC