question about OCIFetchInto

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hi

XP+IIS5.1+PHP4.3+ORACLE9.2(client)

<?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);
?>

ERROR REPORT as follow:

Warning: OCIFetchInto: ORA-01002: ???? in C:\MyPHP\test.php on line 18
Error - no rows returned!


thanks!



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux