Re: [PHP-DB] Using oci_execute

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx> 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@xxxxxxxxxx  Tel: +1 650 506 8630
> Twitter:  http://twitter.com/ghrd    Free PHP Book:
> http://tinyurl.com/f8jad
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux