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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: mc_hades at yahoo dot com
New email:
PHP Version: OS:

 

 [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: Thu Oct 10 09:01:26 2024 UTC