Hi All,
My Apache logs are showing errors similar to the following:
PHP Warning: oci_fetch_all() [
function.oci-fetch-all]: ORA-24374: define not done before fetch or execute and fetch in C:\Sebastian\pbuuc\auction\auction_functions.php on line 90
Here is a snippet from auction_functions.php, line 90 is the call to oci_fetch_all
Not sure what I'm doing wrong.
$stid = oci_parse($conn, $query);
if (! $stid)
{
$dberr = oci_error($conn);
$emsg[$msgnum++] = $dberr['message'];
display_message_page('Database Error', $emsg,'/auction/auction_users_maintenance.php','add_user');
exit;
}
$r = oci_execute($stid, OCI_DEFAULT);
if (! $r)
{
$dberr = oci_error($stid);
$emsg[$msgnum++] = $dberr['message'];
display_message_page('Database Error',$emsg,'/auction/auction_users_maintenance.php','add_user');
exit;
}
$resultcount = oci_fetch_all($stid, $results); <--- this is line 90
oci_free_statement($stid);