|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2006-01-24 12:13 UTC] max__payne at list dot ru
Description:
------------
Calls to oci_parse() sometimes hangs up server. Oracle server is Oracle 8.1.7.0.0 with update to 8.1.7.2.1 running under Windows 2000 Server SP 4 (P IV CPU).
With older versions of PHP (5.0.5) this code works fine.
Reproduce code:
---------------
$connection = oci_connect($username, $password, $tns_name);
$st = oci_parse($connection, "SELECT * FROM nextmonthbirthdays");
oci_execute($st, OCI_DEFAULT);
$res = oci_fetch_assoc($st);
while($res)
{
echo $res{"FIO"} . "<br>";
$res = oci_fetch_assoc($st);
}
oci_free_statement($st);
oci_close($connection);
Expected result:
----------------
List of names one per line expected, instead see nothing while script is running.
Actual result:
--------------
Script above has no output, it hangs up server.
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Oct 29 16:00:01 2025 UTC |
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); ?>