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
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
28 - 22 = ?
Subscribe to this entry?

 
 [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-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 18 14:01:31 2024 UTC