Jump to content


Photo

Problems with OCIFetchInto


  • Please log in to reply
No replies to this topic

#1 Harijs

Harijs
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 09 May 2006 - 01:47 PM

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!





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users