Req #73038 [Com]: Timeout for oci_execute
| From: | camporter1 at gmail dot com | Date: | Thu, 03 Jan 2019 21:21:50 +0000 |
| Subject: | Req #73038 [Com]: Timeout for oci_execute | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-218782@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=73038&edit=1
ID: 73038
Comment by: camporter1 at gmail dot com
Reported by: lukcuc at yahoo dot com
Summary: Timeout for oci_execute
Status: Open
Type: Feature/Change Request
Package: OCI8 related
PHP Version: Irrelevant
Block user comment: N
Private report: N
New Comment:
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
Previous Comments:
------------------------------------------------------------------------
[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