ID: 40727
Updated by: [EMAIL PROTECTED]
Reported By: t_wiedmann at t-online dot de
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: window server 2003
PHP Version: 5.2.1
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.
Previous Comments:
------------------------------------------------------------------------
[2007-03-06 12:03:59] t_wiedmann at t-online dot de
sorry, but I cannot show you this code, PLSQL, tables..
I think, it's some PDO problem if there is
$stmt->bindParam(':p12', $nStatus, PDO::PARAM_INT |
PDO::PARAM_INPUT_OUTPUT, 22 );
without any correspondent named parameters (':p12')
in $sQuery.
Many thanks
Thomas
------------------------------------------------------------------------
[2007-03-06 10:45:11] [EMAIL PROTECTED]
I don't see any crash there and your code does not work - I don't have
your PL/SQL procedures, tables etc.
------------------------------------------------------------------------
[2007-03-06 08:20:58] t_wiedmann at t-online dot de
Please look a this sample. It shows some ORACLE/PLSQL access.
Maybe I fix the problem. There are two mistakes in the code:
(1) without this, Apache will crash
(2) maybe some problem, first use of $nStatus without $nStatus = null;
Hope this helps,
Thomas
-------------------------------------------------------
$sQuery = '';
$sQuery = $sQuery . 'BEGIN ';
$sQuery = $sQuery . ' myTable.Read(:p1); ';
$sQuery = $sQuery . ' myTable.GetnGroup_id(:p2); ';
$sQuery = $sQuery . ' myTable.GetnStatus(:p12); '; // (1) I forgot
this Line
$sQuery = $sQuery . 'END; ';
$stmt = $dbh->prepare($sQuery);
if ($stmt) {
$stmt->bindParam(':p1', $df_nWorkflow_id, PDO::PARAM_INT |
PDO::PARAM_INPUT_OUTPUT, 22 );
$stmt->bindParam(':p2', $df_nGroup_id, PDO::PARAM_INT |
PDO::PARAM_INPUT_OUTPUT, 22 );
$stmt->bindParam(':p12', $nStatus, PDO::PARAM_INT |
PDO::PARAM_INPUT_OUTPUT, 22 ); // (2) $nStatus no init to NULL
$stmt->execute();
$stmt->closeCursor();
$stmt = null;
}
---------------------------------------------
------------------------------------------------------------------------
[2007-03-05 15:46:04] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
------------------------------------------------------------------------
[2007-03-05 13:33:32] t_wiedmann at t-online dot de
Description:
------------
I get the same problem mit Apache 2.2.4 like #40229.
Apache restart with:
[Mon Mar 05 13:21:16 2007] [notice] Parent: child process exited with
status 3221225477 -- Restarting.
[Mon Mar 05 13:21:16 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.1
configured -- resuming normal operations
[Mon Mar 05 13:21:16 2007] [notice] Server built: Jan 9 2007 23:17:20
Reproduce code:
---------------
* Apache 2.2.4
* PDO
* PHP/5.2.1
* Oracle 10g
* Window Server 2003
Expected result:
----------------
No restart
Actual result:
--------------
Apache restart - connection failed
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=40727&edit=1
