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
 [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: Thu Nov 26 16:01:23 2020 UTC