ID: 32718
Updated by: [EMAIL PROTECTED]
Reported By: jogodinho at gms dot pt
Status: Open
Bug Type: OCI8 related
Operating System: Windows XP Professional
PHP Version: 5.0.4
New Comment:
FYI: The PHP 4.3.11 is really the latest stable version, PHP 5.0.x is
something less stable..
Previous Comments:
------------------------------------------------------------------------
[2005-04-15 14:00:00] jogodinho at gms dot pt
Description:
------------
Recently i have submit a upgrade from version PHP4.2.3 to PHP5.0.4
(last stable version available) and now i have some problems of
scability that they didn't happen before.
I establish a connection with a data base with following code:
----
$conn=OCILogon("user", "pass", "bd");
---
And when i submit a query (that it delays 28 seconds approximately, to
return 76000 registers) with the function OCIParse, other sessions that
they intend to establish connections apparently locks, waiting that
query finishes and sometimes i get the following warning:
---
Warning: ocifetch() [<a
href='function.ocifetch'>function.ocifetch</a>]: OCIFetch: ORA-01001:
invalid cursor in ... on line 253
Reproduce code:
---------------
$conn=OCILogon("user", "pass", "bd");
$query = "select ...";
$stmt = OCIParse($conn, $query);
OCIExecute($stmt, OCI_DEFAULT);
while(OCI_Fetch($stmt))
{
OCIResult($stmt, 1);
(...)
}
Expected result:
----------------
Obtain query results
Actual result:
--------------
While the query is running, others sessions locks and sometimes i get
the warning:
---
Warning: ocifetch() [<a
href='function.ocifetch'>function.ocifetch</a>]: OCIFetch: ORA-01001:
invalid cursor in ... on line 253
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32718&edit=1
