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

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 10:01:29 2024 UTC