ID: 42841
Updated by: [EMAIL PROTECTED]
Reported By: pr0head at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Linux version 2.6.20-gentoo-r8
PHP Version: 5.2.4
New Comment:
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
+------------------------------------------------------------
| I couldn't reproduce it.
| Thanks for reporting the bug, but please include a complete
| testcase so I don't have to guess what the code might be.
| Also, what does "stop work" mean?
+------------------------------------------------------------
Previous Comments:
------------------------------------------------------------------------
[2007-10-03 15:39:01] pr0head at gmail dot com
Description:
------------
If you have two or more times the same stored procedure where the
cursor name the same ( :cursor ), PHP stop work.
Reproduce code:
---------------
$connection = oci_connect( .... );
// First execute SP
$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 );
while( $row = oci_fetch_array( $cursor ) ) { .... }
oci_free_statement( $stmt );
oci_free_statement( $cursor );
Expected result:
----------------
If the cursor names are not different ( first - :cursor1, second -
:cursor2), the challenges are successful.
If not cleaned cursor to the first call, and declare it in the second,
the queries are also successful.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=42841&edit=1
