Bug #70302 [NoF->Opn]: Parameter bind with OCI8 is broken - always last parameter value bound to all
| From: | requinix@php.net | Date: | Sun, 06 Sep 2015 04:48:43 +0000 |
| Subject: | Bug #70302 [NoF->Opn]: Parameter bind with OCI8 is broken - always last parameter value bound to all | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-195797@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=70302&edit=1
ID: 70302
Updated by: requinix@php.net
Reported by: deepdiver at owncloud dot com
Summary: Parameter bind with OCI8 is broken - always last
parameter value bound to all
-Status: No Feedback
+Status: Open
Type: Bug
Package: OCI8 related
Operating System: Linux
PHP Version: 7.0.0beta3
Assigned To: sixd
Block user comment: N
Private report: N
Previous Comments:
------------------------------------------------------------------------
[2015-09-06 04:22:18] php-bugs at lists dot php dot net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.
------------------------------------------------------------------------
[2015-08-24 20:43:54] deepdiver at owncloud dot com
Results are the same with master as of just now.
------------------------------------------------------------------------
[2015-08-24 07:52:37] sixd@php.net
You logged this with 7.0.0beta3. Can you test with master? The most recent OCI8 fixes did not get
into Beta3.
------------------------------------------------------------------------
[2015-08-23 23:08:27] sixd@php.net
Your non-failing, pure OCI8 testscript didn't use an array for A,B,C unlike the earlier code.
Try changing the OCI8 test to be closer to the original. And then review the test suites diffs to
see if the problem is related to one of the known test failures.
------------------------------------------------------------------------
[2015-08-20 08:55:52] deepdiver at owncloud dot com
Here is a pure OCI based script - which works \o/ - maybe a doctrine error then ....
<?php
function e($e) {
if (!$e) {
$e = oci_error();
var_dump($e);
exit;
}
}
$conn = oci_connect('autotest', 'owncloud', '172.17.0.1/XE');
e($conn);
// drop table
$stid = oci_parse($conn, 'DROP TABLE TEST');
e($stid);
$r = oci_execute($stid);
e($r);
// create
$stid = oci_parse($conn, 'CREATE TABLE TEST(A VARCHAR2(4000) NOT NULL, B VARCHAR2(4000) NOT
NULL, C VARCHAR2(4000) NOT NULL)');
e($stid);
$r = oci_execute($stid);
e($r);
// insert
$stid = oci_parse($conn, 'INSERT INTO TEST (A, B, C) VALUES(:a, :b, :c)');
e($stid);
$a = 1;
$b = 2;
$c = 3;
oci_bind_by_name($stid, ':a', $a);
oci_bind_by_name($stid, ':b', $b);
oci_bind_by_name($stid, ':c', $c);
$r = oci_execute($stid); // executes and commits
e($r);
// select
$stid = oci_parse($conn, 'SELECT * FROM TEST');
e($stid);
$r = oci_execute($stid); // executes and commits
e($r);
$data = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS);
var_dump($data);
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=70302
--
Edit this bug report at https://bugs.php.net/bug.php?id=70302&edit=1