Warning: OCIFetchInto: ORA-01002: ????
| From: | ys_zhu | Date: | Thu, 16 Jan 2003 14:37:59 +0000 |
| Subject: | Warning: OCIFetchInto: ORA-01002: ???? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-131864@lists.php.net to get a copy of this message | ||
hello all:
XP+IIS5.1+PHP4.3+ORACLE9.2(client)
ERROR REPORT as follow:
Warning: OCIFetchInto: ORA-01002: ???? in C:\MyPHP\test.php on line 18
Error - no rows returned!
test.php:
<?php
if (empty($offset) || $offset < 0)
$offset=0;
}
$limit = 3;
$conn = OCILogon("userid", "userpasswd", "SID");
if (!$conn)
echo "<h1>ERROR - Could not connect to Oracle</h1>";
exit;
}
$sql = "Select count(*) from t1";
$stmt = OCIParse($conn, $sql);
if(!$stmt)
echo "<h1>ERROR - Could not parse SQL statement.</h1>";
exit;
}
OCIExecute($stmt);
OCIFetchInto($stmt, &$total_rows);
if ( !$total_rows[0] )
echo "<h1>Error - no rows returned!</h1>";
exit;
}
echo "There are $total_rows[0] results.<br>\n";
echo "Now showing results $begin to $end.<br><br>\n";
OCIFreeStatement($stmt);
?>
please help me, thanks!