[PHP-DB] Using oci_execute
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 brbrExecute...; $r = oci_execute($stmt); if (!$r) { $erro = oci_error($stmt); trataErroSQL($conn, $consulta, $erro, execute); } echo brbrFim do Execute...; return $r; }
Re: [PHP-DB] Using oci_execute
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 brbrExecute...; $r = oci_execute($stmt); if (!$r) { $erro = oci_error($stmt); trataErroSQL($conn, $consulta, $erro, execute); } echo brbrFim 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: [EMAIL PROTECTED] Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] 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 [EMAIL PROTECTED] 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 brbrExecute...; $r = oci_execute($stmt); if (!$r) { $erro = oci_error($stmt); trataErroSQL($conn, $consulta, $erro, execute); } echo brbrFim 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: [EMAIL PROTECTED] Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/f8jad
Re: [PHP-DB] Using oci_execute
Walter Galvão wrote: 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. I'd start by looking at the max_execution_time and memory_limit settings in php.ini. Chris -- Email: [EMAIL PROTECTED] Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] Re: [PHP-DB] Using oci_execute
Walter Galvão wrote: 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.* error_reporting(E_ALL); ini_set('display_errors', true); Any warnings/notices? -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php