PHP 4.0 Bug #5767: OCIBind/OCIStmtExecute error
| From: | spam at sporty dot org | Date: | Mon, 24 Jul 2000 21:11:33 +0000 |
| Subject: | PHP 4.0 Bug #5767: OCIBind/OCIStmtExecute error | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-25837@lists.php.net to get a copy of this message | ||
From: spam@sporty.org
Operating system: Redhat linux
PHP version: 4.0.1pl2
PHP Bug Type: Misbehaving function
Bug description: OCIBind/OCIStmtExecute error
After speaking with oracle, they claim i am not inserting an integer when doing this. I was also
asked to set an environment variable to ensure i'm using 7 bit ascii. I can rewrite the
function in perl and succeed with it.
---
if(!$stmt=OCIParse($dbh,"delete from mstats where job_num=$jobnum and
message_id=to_number(:mid)"))
return(0);
OCIBindByName($stmt,":mid",&$mid);
foreach ($messageIDs as $mid)
{
settype($mid,"Integer");
print gettype($mid);
if(validMessageId($mid))
OCIExecute($stmt);
}
--
i use the settype to just make sure, as well as the to_number. php/oracle generates this error.
OCIStmtExecute: ORA-01460: unimplemented or unreasonable conversion requested in [filename and line
number]
help!