ID: 37698 User updated by: james at redeye dot com Reported By: james at redeye dot com -Status: Feedback +Status: Open Bug Type: PDO related Operating System: Linux Advanced Server 3.4 PHP Version: 5.1.4 New Comment:
Can't use the latest Oracle Instant Client as I use the ssh library and using the Oracle 10g client causes this not to work. It only works with the 9i client. Using Toad and the Oracle 9i client the query works fine. Using Toad and the Oracle 10g client the query works fine also. Previous Comments: ------------------------------------------------------------------------ [2006-06-05 09:49:17] [EMAIL PROTECTED] Doesn't seem to be related to PHP.. Please try to rebuild PHP with the latest Oracle Instant Client and see if it helps. See also bug #36607. ------------------------------------------------------------------------ [2006-06-05 09:42:34] james at redeye dot com #0 0x011e0009 in ttcfopr () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #1 0x011d6341 in ttcdrv () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #2 0x0104636d in nioqwa () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #3 0x00ef9ec0 in upirtrc () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #4 0x00ea294d in kpurcsc () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #5 0x00e62ff9 in kpuexecv8 () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #6 0x00e64abe in kpuexec () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #7 0x00ec3c2c in OCIStmtExecute () from /u01/app/oracle/product/920/lib/libclntsh.so.9.0 #8 0x080ff70b in oci_stmt_execute (stmt=0x9174a74) at /usr/local/src/php-5.1.4/ext/pdo_oci/oci_statement.c:142 #9 0x080f8bc9 in zif_PDOStatement_execute (ht=0, return_value=0x916f6ec, return_value_ptr=0x0, this_ptr=0x916f7d4, return_value_used=0) at /usr/local/src/php-5.1.4/ext/pdo/pdo_stmt.c:451 #10 0x081fc669 in zend_do_fcall_common_helper_SPEC (execute_data=0xbfff8bb0) at zend_vm_execute.h:200 #11 0x081fbf8d in execute (op_array=0x916b394) at zend_vm_execute.h:92 #12 0x00592920 in zend_oe () from /usr/local/Zend/lib/Optimizer-2.6.1/php-5.1.x/ZendOptimizer.so #13 0x0916b394 in ?? () #14 0x0090d180 in run_fp () from /lib/tls/libc.so.6 #15 0x00000df0 in ?? () #16 0xbfff8c28 in ?? () #17 0x00848e9d in malloc () from /lib/tls/libc.so.6 ------------------------------------------------------------------------ [2006-06-05 08:44:29] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. ------------------------------------------------------------------------ [2006-06-05 08:17:12] james at redeye dot com Description: ------------ I have a synonym in my Oracle 10g database that points to a table on a 9i database. A database link is used to do this. If I do a select * on this table a segmentation fault is produced in php. If I do the select with a where clause or by specifying the fields I want then PHP works ok Reproduce code: --------------- select * from segment // Causes segmentation fault select * from segment where name like '%MR%' // works ok select name from segment // works ok Expected result: ---------------- returns the matches from the sql. Actual result: -------------- PHP segmentation fault. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37698&edit=1