ID: 42841 Updated by: [EMAIL PROTECTED] Reported By: pr0head at gmail dot com Status: Open Bug Type: OCI8 related Operating System: Linux version 2.6.20-gentoo-r8 PHP Version: 5.2.4 New Comment:
I reproduced the crash. The problem appears to be the same as reported in http://bugs.php.net/bug.php?id=43340. If you change the PL/SQL package definition so out_1 is an "IN OUT" parameter, there is no crash. Previous Comments: ------------------------------------------------------------------------ [2007-11-20 09:46:48] pr0head at gmail dot com This script working normally if not reopen cursor. Bad result: $sql = "BEGIN sp_vadik_1( :cursor ); END;"; $stmt = oci_parse( $connection, $sql ); $cursor = oci_new_cursor( $connection ); oci_bind_by_name( $stmt, ":cursor", $cursor, -1, OCI_B_CURSOR ); oci_execute( $stmt, OCI_DEFAULT ); oci_execute( $cursor ); oci_free_statement( $stmt ); oci_free_statement( $cursor ); $sql = "BEGIN sp_vadik_1( :cursor ); END;"; $stmt = oci_parse( $connection, $sql ); $cursor = oci_new_cursor( $connection ); oci_bind_by_name( $stmt, ":cursor", $cursor, -1, OCI_B_CURSOR ); oci_execute( $stmt, OCI_DEFAULT ); oci_execute( $cursor ); oci_free_statement( $stmt ); oci_free_statement( $cursor ); Good result: $sql = "BEGIN sp_vadik_1( :cursor ); END;"; $stmt = oci_parse( $connection, $sql ); $cursor = oci_new_cursor( $connection ); oci_bind_by_name( $stmt, ":cursor", $cursor, -1, OCI_B_CURSOR ); oci_execute( $stmt, OCI_DEFAULT ); oci_execute( $cursor ); oci_free_statement( $stmt ); $sql = "BEGIN sp_vadik_1( :cursor ); END;"; $stmt = oci_parse( $connection, $sql ); oci_bind_by_name( $stmt, ":cursor", $cursor, -1, OCI_B_CURSOR ); oci_execute( $stmt, OCI_DEFAULT ); oci_execute( $cursor ); oci_free_statement( $stmt ); oci_free_statement( $cursor ); ------------------------------------------------------------------------ [2007-11-20 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2007-11-12 10:35:02] [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. ------------------------------------------------------------------------ [2007-10-04 08:38:08] pr0head at gmail dot com "stop work" - this crash PHP. If run this script in command line, i see error "segmentation false" ------------------------------------------------------------------------ [2007-10-04 08:27:01] pr0head at gmail dot com Sorry, need change lines in EXECUTE 2 (for reproduction errors). SQL and bind param must be the same for both executions: $sql = "BEGIN sp_vadik_1( :cursor ); END;"; oci_bind_by_name( $stmt, ":cursor", $cursor, -1, OCI_B_CURSOR ); ------------------------------------------------------------------------ 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 http://bugs.php.net/42841 -- Edit this bug report at http://bugs.php.net/?id=42841&edit=1
