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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or 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

Add a Patch

Pull Requests

Add a Pull Request

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-2020 The PHP Group
All rights reserved.
Last updated: Mon Nov 30 12:01:23 2020 UTC