ID: 36139
Comment by: v_afan at fareastone dot com dot tw
Reported By: max__payne at list dot ru
Status: No Feedback
Bug Type: OCI8 related
Operating System: Win 2003 Server Standard R2
PHP Version: 5.1.2
New Comment:
I am aware that the issue is reported by someone else on prior versions
of PHP 5.x, and I am aware the issue is reportedly resolved, but the
crash problem of the PHP 5.x SAPI for Apache appears to have risen
again.
I used the following code on PHP 5.1.2 (SAPI) on both Apache 2.0
(official binaries) and 2.2 (compiled SAPI module with VC .Net 2003) on
Windows XP SP2, and Apache would crash with a Windows dialog box that
indicates the crash. Through trial and error through comment blocks, I
found that Apache crashed upon executing "OCI_PARSE($conn,$sql);", where
the connection to the Oracle DB server via a local client appears to
have been successful (Oracle client 8.1.7.0.0 connecting to Oracle
server 8.1.7.4.0).
Interestingly though, the following code does work successfully (as
expected) for both Apache 2.0 and 2.2 when used in conjunction with
their corresponding PHP SAPI modules from PHP 5.1.1 on the same
combination of OS, compiler, oracle client and server.
Thanks for the time, and I would still like to thank the PHP devs on
their works on this great program.
--------------CODE used to trigger the crash on PHP 5.1.2--
<?
$un = 'someone';
$pw = 'foo';
$db = 'somedb';
$conn = oci_connect($un, $pw, $db);
if (!$conn)
{
echo("DB Connection failed!");
exit;
}
$dev_id = $_POST["dev_id"];
$sql = 'SELECT FOO FROM SOME_TABLE WHERE DEV_ID = :DEV';
$qry = OCI_PARSE($conn,$sql);
OCI_BIND_BY_NAME($qry, ":DEV", $dev_id, -1);
OCI_EXECUTE($qry);
?>
Previous Comments:
------------------------------------------------------------------------
[2006-02-02 01:00:04] 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".
------------------------------------------------------------------------
[2006-01-25 08:25:22] max__payne at list dot ru
I use client Oracle 9i client libraries. They are not compatible with
PHP 5.1.2?
------------------------------------------------------------------------
[2006-01-24 20:15:39] [EMAIL PROTECTED]
>Oracle Call Interface
I'm sure it's OCI, but I was asking about its version.
I mean are you using Oracle Instant Client _10_ or old libraries from
Oracle _8i_ or _9i_ ?
Short version: install Instant Client and see if it works.
------------------------------------------------------------------------
[2006-01-24 19:26:58] max__payne at list dot ru
Oracle Call Interface
Revision: 1.257.2.8
------------------------------------------------------------------------
[2006-01-24 12:28:45] [EMAIL PROTECTED]
What version of client libraries are you using?
------------------------------------------------------------------------
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/36139
--
Edit this bug report at http://bugs.php.net/?id=36139&edit=1
