Req #73038 [Opn->Csd]: Timeout for oci_execute

Edit report at https://bugs.php.net/bug.php?id=73038&edit=1 ID: 73038 Updated by: cmb@php.net Reported by: lukcuc at yahoo dot com Summary: Timeout for oci_execute -Status: Open +Status: Closed Type: Feature/Change Request Package: OCI8 related PHP Version: Irrelevant -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: Fine, so this ticket can be closed. Previous Comments: ------------------------------------------------------------------------ [2019-01-03 21:21:50] camporter1 at gmail dot com PHP 7.2.14, PHP 7.3.1, and newer PECL OCI8 support timeouts now when using 18c client libraries: https://secure.php.net/manual/en/function.oci-set-call-timout.php ------------------------------------------------------------------------ [2018-12-08 10:36:46] sixd@php.net Oracle 18c client libraries support a call timeout setting. This would need to be exposed in OCI8. It has the behaviors noted in https://oracle.github.io/node-oracledb/doc/api.html#dbcalltimeouts ------------------------------------------------------------------------ [2016-09-07 10:53:10] lukcuc at yahoo dot com Description: ------------ Would it be possible to put a timeout on oci_execute. Ex. $comm=oci_connect($user,$pass,$db) $stmp=oci_parse($p_conn,"..."); oci_execute($stmt,OCI_DEFAULT,5); The statement would then timeout after 5s returning ORA-01013 or similar and leaving the connection open. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=73038&edit=1