ID: 39988 Updated by: [EMAIL PROTECTED] Reported By: christopher dot jones at oracle dot com -Status: Assigned +Status: Closed Bug Type: OCI8 related Operating System: n/a PHP Version: 5.2.0 Assigned To: tony2001 New Comment:
This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2006-12-29 22:21:29] christopher dot jones at oracle dot com Description: ------------ The datatype passed to oci_define_by_name() is ignored. Patch is something like: Index: oci8_interface.c =================================================================== RCS file: /repository/php-src/ext/oci8/oci8_interface.c,v retrieving revision 1.8.2.7.2.6 diff -u -r1.8.2.7.2.6 oci8_interface.c --- oci8_interface.c 21 Dec 2006 22:08:26 -0000 1.8.2.7.2.6 +++ oci8_interface.c 29 Dec 2006 22:10:30 -0000 @@ -52,7 +52,7 @@ zval *stmt, *var; char *name; int name_len; - long type = SQLT_CHR; + long type = 0; php_oci_statement *statement; php_oci_define *define, *tmp_define; Index: oci8_statement.c =================================================================== RCS file: /repository/php-src/ext/oci8/oci8_statement.c,v retrieving revision 1.7.2.14.2.17 diff -u -r1.7.2.14.2.17 oci8_statement.c --- oci8_statement.c 25 Dec 2006 21:47:02 -0000 1.7.2.14.2.17 +++ oci8_statement.c 29 Dec 2006 22:10:30 -0000 @@ -506,7 +506,11 @@ /* find a user-setted define */ if (statement->defines) { - zend_hash_find(statement->defines,outcol->name,outcol->name_len,(void **) &outcol->define); + if (zend_hash_find(statement->defines,outcol->name,outcol->name_len,(void **) &outcol->define) == SUCCESS) { + if (outcol->define->type) { + outcol->data_type = outcol->define->type; + } + } } buf = 0; Reproduce code: --------------- These two queries incorrectly produce the same results: $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $fi, SQLT_STR)); oci_execute($stmt); while (oci_fetch($stmt)) { echo "file md5:" . md5($fi) . "\n"; } $stmt = oci_parse($c, "SELECT fileimage FROM phptestrawtable"); var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $fi)); oci_execute($stmt); while (oci_fetch($stmt)) { echo "file md5:" . md5($fi) . "\n"; } I'll mail a full .phpt testcase to Tony. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39988&edit=1
