Would anyone happen to know how to use OCI bound variables in a SQL "where in" context?
For example:
Code: Select all
select * from employee where id in (1, 2, 3, 4, 5);In effect, I would try something like this:
Code: Select all
$theDB = OCILogon ("employee", "employee", "employee");
$sql = "select * from employee where id in (:list)";
$resource = OCIParse($theDB, $sql);
OCIBindByName($resource, ":list", $_GET['list']);
OCIExecute($resource);