Bug #70302 [Fbk->NoF]: Parameter bind with OCI8 is broken - always last parameter value bound to all

Edit report at https://bugs.php.net/bug.php?id=70302&edit=1 ID: 70302 Updated by: php-bugs@lists.php.net Reported by: deepdiver at owncloud dot com Summary: Parameter bind with OCI8 is broken - always last parameter value bound to all -Status: Feedback +Status: No Feedback Type: Bug Package: OCI8 related Operating System: Linux PHP Version: 7.0.0beta3 Assigned To: sixd Private report: N New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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); ------------------------------------------------------------------------ [2015-08-20 04:07:21] sixd@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. Your subject says "OCI", the category says "PDO_OCI" but the sample code indicates you might mean OCI8. Can you clarify and also supply a runnable testcase that doesn't depend on any 3rd party code? If this is OCI8, is the problem related to one of the known diffs? Try running the test suite. ------------------------------------------------------------------------ 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