I have the following query:
$query = "delete from document where document_lientype =:lienType and document_lienid =:lienId and document_id not in (:docsIds)";
$params = array(
'lienType' => $lienType,
'lienId' => $lienId,
'docsIds' => implode(',',$docsIds)
);
When I dump $docsIds
I get:
array(3) {
[0] =>
int(19357)
[1] =>
int(19358)
[2] =>
int(19378)
}
And when I dump implode(',',$docsIds)
I get:
string(17) "19357,19358,19378"
When I run the query in my project I get the error ORA-01722: invalid number
which means it is not being able to convert the docsIds
into integers.
When I run the query in TOAD, it executes correctly; so the problem is coming from that in
clause.
I tried to construct the string in all the ways I could imagine of, including: "'19357','19358','19378'"
but I still get the same error.