Re: Using oci_execute

What version of PHP? *5* What version of Instant Client? * instantclient-basic-win32-10.2.0.3-20061115* What version of the DB? *10G * Are you exceeding the PHP script time out, or exceeding the memory limit? *I dont know. Doesnt appear any message. The script prints the last message before the oci_execute call.* Is there an error from oci_parse or your fetch call? *No* Which fetch call are you using? *The problem is in oci_execute, because between the oci_execute and fetch call there is a echo that script doesnt print. The fetch call is oci_fetch_all* Does your error occur when there are lots of rows, or only when your query contains a certain kind of datatype? *When there are lots of rows.* Thanks! Chris On 9/29/08, Christopher Jones <christopher.jones@oracle.com> wrote: > > > > Walter Galvão wrote: > >> Hi, >> >> Im using the oracle instant client basic in my php app, with apache >> server. >> When a query returns few rows, there is no problem. >> Otherwise, the oci_execute method doesn return any records neither errors! >> How can i solve this problem?? >> >> My implementation: >> >> function executarSQL($conn, $stmt, $consulta){ >> echo "<br><br>Execute..."; >> >> $r = oci_execute($stmt); >> >> if (!$r) { >> $erro = oci_error($stmt); >> trataErroSQL($conn, $consulta, $erro, "execute"); >> } >> echo "<br><br>Fim do Execute..."; >> return $r; >> } >> >> > What version of PHP? What version of Instant Client? What version of > the DB? > > Are you exceeding the PHP script time out, or exceeding the memory > limit? > > Is there an error from oci_parse or your fetch call? > > Which fetch call are you using? > > Does your error occur when there are lots of rows, or only when your > query contains a certain kind of datatype? > > Chris > > -- > Email: christopher.jones@oracle.com Tel: +1 650 506 8630 > Twitter: http://twitter.com/ghrd Free PHP Book: > http://tinyurl.com/f8jad >