|  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
Have you experienced this issue?
Rate the importance of this bug to you:

 [2006-11-21 10:14 UTC] mc_hades at yahoo dot com
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);

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


Expected result:
The connection being closed.

Actual result:
The connection hangs on the ORACLE server.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2006-11-21 14:12 UTC]
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: Sat Jul 20 08:01:28 2024 UTC