php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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-2025 The PHP Group
All rights reserved. 		Last updated: Mon Apr 21 03:01:25 2025 UTC