php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #39569 OCI_Close doesn't close the connection.
Submitted: 2006-11-21 10:14 UTC Modified: 2006-11-29 01:00 UTC
From: mc_hades at yahoo dot com Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 5.2.0 OS: HP-UX
Private report: No CVE-ID: None
 [2006-11-21 10:14 UTC] mc_hades at yahoo dot com
Description:
------------
I want to explicitly close the connection, because the timeout on the ORACLE server is huge and it cannot be modified.

OciLogOff does not close the connection. I tried using the "current functions": oci_connect, oci_fetch_array, etc, but the connection still hangs. I also tried oci_new_connect, with no luck.

Reproduce code:
---------------
$conn = OCILogon('*******', '*****', '******');
$query = "SELECT struct_name AS STR_NAME FROM STRUCTURES ";

$stid = OCIParse($conn, $query);
OCIExecute($stid);

while (OCIFetchInto($stid, $row,OCI_ASSOC))
 {echo $row['STR_NAME'];
 echo "<br>";};

OCIFreeStatement($stid);
OCILogOff($conn);


Expected result:
----------------
The connection being closed.

Actual result:
--------------
The connection hangs on the ORACLE server.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-11-21 14:12 UTC] tony2001@php.net
How exactly did you ensure that the connection still "hangs"? Please show your phpinfo().
 [2006-11-29 01:00 UTC] 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".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Dec 03 13:01:28 2024 UTC