RE: [PHP-DB] OCI8

Thanks for your help, but i tried with OCIPLogon, and get same result. -----Message d'origine----- De : Ford, Mike [LSS] [mailto:M.Ford@leedsmet.ac.uk] Envoyé : vendredi 13 août 2004 16:03 À : 'yannick'; php-db@lists.php.net Objet : 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