ID: 36607 Updated by: [EMAIL PROTECTED] Reported By: jreed at myers dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Linux - 386 PHP Version: 5.1.2 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip Please provide the backtrace if you're still able to reproduce it with the latest snapshot. Previous Comments: ------------------------------------------------------------------------ [2006-03-03 20:13:25] jreed at myers dot com Description: ------------ When oci8.default_prefetch is set to anything but zero, executing a SQL statement that uses a dbLink and only returns a single row causes Apache to seg fault. If oci8.default_prefetch is set to zero then it works fine. This problem only seems to occur if you do a SELECT *. If you identify the exact columns to select then it works fine. Also, the same statement works fine, even with SELECT *, if you connect to the database directly. It only fails if accessing through a dbLink. Reproduce code: --------------- $sql = " select * from [EMAIL PROTECTED] where table_id = $some_id "; $stmt = ociparse($conn, $sql); ociexecute($stmt, OCI_DEFAULT); ocifetchinto($stmt, $row, OCI_ASSOC); ocifreestatement($stmt); Expected result: ---------------- $row is a populated associative array with all the columns from the table row requested. Actual result: -------------- Apache seg faults immediately after the ociexecute() call. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36607&edit=1
