RE: [PHP-DB] OCI8

On 13 August 2004 13:29, yannick wrote: > I have some trouble with Oracle Database and php... > > see this code: > <? > while (1) { > $conn=OCILogon($username,$password,$database); Try OCIPLogon() rather than OCILogon(). > $stmt=OCIParse($conn,"select 50 as toto from dual"); > OCIDefineByName($stmt,"TOTO",&$total); Not related to your problem, but you don't need that & -- in fact, it's deprecated and may, one day, cause a parse error. > OCIExecute($stmt); > OCIFetch($stmt); > echo ":::$total:::\n"; > OCILogoff($conn); > $err=OCIError($conn); > OCILogoff($conn); > sleep(10); > } > > > > when i execute it, the number of fd on ocius.msg is growing. but > there is only 1 connection at database. > > Can someone help me ? Cheers! Mike --------------------------------------------------------------------- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Services, JG125, James Graham Building, Leeds Metropolitan University, Headingley Campus, LEEDS, LS6 3QS, United Kingdom Email: m.ford@leedsmet.ac.uk Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211