|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2001-06-01 06:43 UTC] 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)
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Thu Dec 26 13:01:30 2024 UTC |
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.