php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #73038 Timeout for oci_execute
Submitted: 2016-09-07 10:53 UTC Modified: 2020-03-10 11:38 UTC
Votes:4
Avg. Score:4.0 ± 1.0
Reproduced:2 of 2 (100.0%)
Same Version:1 (50.0%)
Same OS:1 (50.0%)
From: lukcuc at yahoo dot com Assigned: cmb (profile)
Status: Closed Package: OCI8 related
PHP Version: Irrelevant OS:
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: lukcuc at yahoo dot com
New email:
PHP Version: OS:

 

 [2016-09-07 10:53 UTC] 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.




Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-12-08 10:36 UTC] 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
 [2019-01-03 21:21 UTC] 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
 [2020-03-10 11:38 UTC] cmb@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: cmb
 [2020-03-10 11:38 UTC] cmb@php.net
Fine, so this ticket can be closed.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Oct 31 23:01:28 2024 UTC