php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #177 Ora_GetColumn returns garbage in end of output
Submitted: 1998-03-15 13:06 UTC Modified: 1998-05-16 02:18 UTC
From: bmeyer at relief dot dk Assigned: rasmus (profile)
Status: Closed Package: Oracle related
PHP Version: 3.0b5 OS: Solaris
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: bmeyer at relief dot dk
New email:
PHP Version: OS:

 

 [1998-03-15 13:06 UTC] bmeyer at relief dot dk
<?
  echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"1\">";
  $conn = Ora_Logon("scott","tiger");
  if ($conn<0) { exit; }
  $cursor = Ora_Open($conn);
  if ($cursor<0) { Ora_Logoff($conn); exit; }
  Ora_CommitOff($conn);
  if (Ora_Parse($cursor, "select sysdate from dual") < 0) { Ora_Logoff($conn); exit; }
  $ncols = Ora_Exec($cursor);
  while (Ora_Fetch($cursor) == 1) {
   $i = 0;
   while ($i<$ncols) {
    $val = Ora_GetColumn($cursor, $i);
    echo "<td align=\"left\" valign=\"top\">";
    echo $val;
    echo "</td>\n";
    $i++;
   }
   echo "<tr>\n";
  }
  Ora_Close($cursor); Ora_Logoff($conn);
?>

Output: "15-MAR-98ATE 9 ?5x+ Kora_fetch ,? ?0?"

Configure: configure --with-apache=/database/apache_1.3b5 --with-mysql=/database/mysql --enable-track-vars --with-oracle=/database/oracle7

Oracle version 7.3


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1998-05-16 02:18 UTC] rasmus
This seems to work fine with the latest CVS and Oracle 8.0.3.  If you still experience this problem after upgrading to the latest CVS release, please resubmit the bug report.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 09:01:29 2024 UTC