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