Hi,
I am able to Exec a simple select query, but can't Fetch any data from the cursor. I know here's data there, as the same query works fine through SQLPlus.
Code:
<?PHP
// Logon to Oracle Server
putenv('ORACLE_HOME=/usr/oracle');
putenv('TWO_TASK=SLAC_TCP');
$Connection = ora_Logon('username', 'password');
if (! $Connection) {
echo...
exit;
}
$Cursor = ora_Open($Connection);
$CountRec = 0;
$Query = "SELECT * FROM TABLE";
ora_Parse($Cursor, $Query, 0);
ora_Exec($Cursor);
ora_Fetch($Cursor);
while(ora_Fetch($Cursor)) {
$CountRec++;
echo "<hr><br>record #: " . $CountRec . "<br>";
echo " ID: " . $PROJ_ID . "<br>";
echo " Name: " . $NAME . "<br>";
echo " Acronym: " . $ACRONYM . "<br>";
echo " Common Name: " . $COMMON_NAME . "<br>";
};
echo "CountRec: " . $CountRec . "<BR>";
echo "OraError: " . Ora_Error($Cursor) , "<BR>"; // <---------- Delete Me
// Logoff to Oracle Server
ora_close($Cursor);
ora_Logoff($Connection);
?>
Ora_Error reports:
OraError: ORA-01403: no data found -- while processing OCI function OFETCH/OFEN
Thx in Advance,
Barry
