#39271 [Opn->Bgs]: oci_bind_array_by_name produces incorrect data

ID: 39271 Updated by: tony2001@php.net Reported By: quelch at udel dot edu -Status: Open +Status: Bogus Bug Type: OCI8 related Operating System: Redhat EL 3 PHP Version: 5.1.6 New Comment: Change SQLT_NUM to SQLT_INT and it works fine. There is no difference for OCI8 between those two bind types (they are handled by the same function in the very same way), so there must be some difference in OCI library itself. Previous Comments: ------------------------------------------------------------------------ [2006-10-26 21:40:18] quelch at udel dot edu I get the same error with the php5.2-200610262030 snapshot as I did with the php5.2-200610261830 snapshot and 5.1.6. Thanks. ------------------------------------------------------------------------ [2006-10-26 20:50:55] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip ------------------------------------------------------------------------ [2006-10-26 20:46:27] quelch at udel dot edu Description: ------------ Utilizing the oci_bind_array_by_name function in Oracle 10.2.0.1 results in incorrect data being returned for NUMBER array data. This error also occurs with the php5.2-200610261830 snapshot. Configure line: ./configure -with-oci8 --with-gd --enable-gd-imgstrttf --enable-gd-native-ttf --with-ttf --with-freetype-dir --with-apxs=/www/bin/apxs --with-png --with-zlib --with-jpeg --enable-xmlwriter --without-pear My database is set up with native code compile option for PL/SQL in case that makes a difference. Reproduce code: --------------- The code used can be found here: http://www-dev.quelch.org/ws/test.html Expected result: ---------------- Array ( [0] => 4 [1] => 3 [2] => 2 [3] => 1 [4] => 0 ) Actual result: -------------- Array ( [0] => 1473 [1] => 1217 [2] => 961 [3] => 705 [4] => 128 ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39271&edit=1