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

go to bug id or search bugs for

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
View Developer Edit
 [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

Pull Requests

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-2024 The PHP Group
All rights reserved. 		Last updated: Thu Dec 26 09:01:29 2024 UTC