ID: 11234
Comment by: katiakreol at yahoo dot fr
Reported By: worawisu at loxinfo dot co dot th
Status: Bogus
Bug Type: OCI8 related
Operating System: Linux Redhat 6.2 (kernel 2.2.14)
PHP Version: 4.0.5
New Comment:
Hi
I have got the same problem!! Ocilogoff does not disconnect!
I absolutely have to use ociplogon and it is very annoying to be unable
to disconnect! There has to be a solution please help!!
Previous Comments:
------------------------------------------------------------------------
[2001-06-03 22:02:37] worawisu at loxinfo dot co dot th
But the problem still when using OCILogon() too with the very simple
code.(I just try every Logon function of OCI. When try each one and
Monitor the session status (from v$session view using Oracle Sql+).
<?php
include("db_config.php");
$conn=OCILogon($User,$Password,$Database);
print "Connection1 = $conn <br>\n";
OCILogoff($conn);
print "Connection2= $conn <br>\n";
?>
Reqard.
------------------------------------------------------------------------
[2001-06-01 11:05:58] [EMAIL PROTECTED]
Well, OCIplogon() opens a PERSISTANT connection.
Use ocilogon() instead.
------------------------------------------------------------------------
[2001-06-01 06:43:01] worawisu at loxinfo dot co dot th
I use OCIPLogon() function to log on to oracle dbms. And when i 'd like
to quit i use OCILogoff(). But the db session also still (don't log off)
.
this is my script:
<?php
$conn=OCIPLogon($usr,$passwd,$host) or die("Cannot Logon to Database
Server");
$sql="select * from my_table ";
$stmt=OCIParse($conn,$sql);
echo "Connection ID 1 = $conn <br>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
echo "Connection ID 2 = $conn <br>\n";
?>
The result of "Connection ID 1 and 2" is "Resource id #1 ";
(If Session in oracle was ended i think Connection ID 2 must be null
value not "Resource id #1" )
This problem still in PHP 4.0.5 (with apache 1.3.20)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=11234&edit=1
