Req #65980 [Opn->Nab]: Allow «IN» statement binding
| From: | sixd@php.net | Date: | Thu, 14 Aug 2014 16:02:32 +0000 |
| Subject: | Req #65980 [Opn->Nab]: Allow «IN» statement binding | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-187125@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=65980&edit=1
ID: 65980
Updated by: sixd@php.net
Reported by: m dot a dot ogarkov at gmail dot com
Summary: Allow «IN» statement binding
-Status: Open
+Status: Not a bug
Type: Feature/Change Request
Package: OCI8 related
Operating System: all supported
PHP Version: 5.5.5
Block user comment: N
Private report: N
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2013-10-28 05:27:37] 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);
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=65980&edit=1