php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #65980 Allow «IN» statement binding
Submitted: 2013-10-28 05:27 UTC Modified: 2014-08-14 16:02 UTC
From: m dot a dot ogarkov at gmail dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 5.5.5 OS: all supported
Private report: No CVE-ID: None
 [2013-10-28 05:27 UTC] m dot a dot ogarkov at gmail dot com
Description:
------------
When dealing with «IN» clause within sql statements it will be convinient to be able to bind php array to expression within brackets in such way:

SELECT ID
FROM TABLE
WHERE ID IN (:host_variable);

$ids = [1,2,3,5,6];
oci_bind_by_name($statement, ":host_variable", $ids);






Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2014-08-14 16:02 UTC] sixd@php.net
-Status: Open +Status: Not a bug
 [2014-08-14 16:02 UTC] sixd@php.net
This is an Oracle limitation, not an OCI8 problem.  Changing it would require Oracle to parse the bound data to identify the delimiters.  This is extremely unlikely to happen.  If you want to pursue it, please log a request with Oracle Corp.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Mon Jan 13 20:01:31 2025 UTC