ID: 40727
User updated by: t_wiedmann at t-online dot de
Reported By: t_wiedmann at t-online dot de
-Status: Feedback
+Status: Open
-Bug Type: Apache related
+Bug Type: PDO related
Operating System: window server 2003
PHP Version: 5.2.1
New Comment:
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
Previous Comments:
------------------------------------------------------------------------
[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
