Jump to content

Archived

This topic is now archived and is closed to further replies.

Harijs

Problems with OCIFetchInto

Recommended Posts

I have PHP 4, i can't use oci_fetch_array and i use OCIFetchInto, but i recieve warning:

Warning: ocifetchinto(): OCIFetchInto: ORA-24374: define not done before fetch or execute and fetch in /home/db.inc.php on line 161

My code fragment:

function Fetching($cursor)
{
if(!ocifetchinto($cursor,$row,OCI_ASSOC))
{
return FALSE;
}
else
{
$result=array();
$keys = (array_keys($row));
foreach ($keys as $k)
{
$result[strtolower($k)]=$row[$k];
}
}
return $result;
}

$sql = "SELECT VALUE FROM scott.table1";
$statement = OCIParse($DB, $sql);
$execute = OCIExecute($statement);

while ($row=Fetching($statement))
{
print($row['value']);
}

This code is printing true results from table, but mostly with ORA-24374 warning. I used this code for different tables and sometimes this code returns results without warnings. Why there is warning? Maybe fragment if(!ocifetchinto($cursor,$row,OCI_ASSOC)) isn't ok? Please, help me!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.