ORA-01460 error when useing bind sql on oracle from php
| From: | Are Pedersen | Date: | Thu, 20 Nov 2003 13:18:47 +0000 |
| Subject: | ORA-01460 error when useing bind sql on oracle from php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31648@lists.php.net to get a copy of this message | ||
I get "ORA-01460: unimplemented or unreasonable conversion requested" when useing bind-sql on Oracle 9i.
I am useing OCI 8.1 client in PHP.
What is wrong? And what does this message mean?
Here is the code:
---***---
$bindarray1=array(':project1'=>$project);
$bindarray1[':userid']=$userid;
$rs = sql_query($qs,$bindarray1);
function sql_query($qs,$bindargs) {
$stmt = @OCIParse($this->db_sqlhandler, $qs);
if (!$stmt) {
return false;} //bind all the variables if (is_array($bindargs)){
foreach ($bindargs as $bindname => $bindvalue){
OCIBindByName($stmt,$bindname,&$bindvalue,-1);
}
}
if (@OCIExecute($stmt)) {
return $stmt;} $DB_ERROR = OCIError($stmt); return $DB_ERROR; } ---***--- vardump of bindargs: array(2) { [":project1"]=> int(1) [":userid"]=> string(5) "10001" } vardump of DB_ERROR: array(4) { ["code"]=> int(1460) ["message"]=> string(62) "ORA-01460: unimplemented or unreasonable conversion requested " ["offset"]=> int(0) ["sqltext"]=> string(365) "SELECT acl.prjid, acl.groupid, acl.read_access , acl.write_access,acl.delete_access,acl.change_access FROM StructureTreeTbl outree, GroupChildrenTbl gg2, MembersTbl memb2, ACL acl WHERE (memb2.personid=:userid AND memb2.groupid=gg2.gchildid AND gg2.groupid=outree.orgchild AND outree.orgid = acl.groupid AND acl.prjid=:project1) " }