ID: 31693
Comment by: terry dot greenlaw at logicalshift dot com
Reported By: Tomasz dot Fryc at bph dot pl
Status: No Feedback
Bug Type: OCI8 related
Operating System: Windows 2003 Server
PHP Version: 5.0.3
New Comment:
I am seeing the same error while using oci_fetch_array().
I am using oci_new_connect('u','pw','db') in my main script.
The script uses oci_fetch_array() to loop through items. Each item has
an image tag which calls another script to fetch a jpg from a blob.
<img src="view_image.php?id=n">.
The view_image.php script also does an oci_new_connect() using the same
credentials, fetches the jpeg from the blob using oci_fetch_array,
outputs the jpeg data stream, and exits.
I am getting sporatic ora-1001 errors. However, if I place a return()
in the view_image.php code before the oci_new_connect(), the main
script does not generate any ora-1001 errors.
I've tried numerous combinations of freeing oracle resources in both
scripts, as well as switching the view_image script to use
oci_connect(), but the problem persists.
Previous Comments:
------------------------------------------------------------------------
[2005-03-08 01:00:30] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2005-02-28 20:57:51] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
------------------------------------------------------------------------
[2005-02-17 11:16:39] Tomasz dot Fryc at bph dot pl
Here is procedure, which described PHP code invokes (in this case $sql
variable looks as follows: "begin
MOA.MOA_EVENT_PKG.GetEventList('param1','param2',...); end;"):
PROCEDURE GetEventsList
(
P_UGP_ID IN NUMBER,
P_HST_ID IN NUMBER,
P_HST_GRP_ID IN NUMBER,
P_DAYS IN NUMBER,
P_CURSOR OUT c_event,
P_ERR_CODE OUT NUMBER,
P_ERR_DESC OUT VARCHAR2
)
IS
BEGIN
IF P_HST_ID = 0 AND P_HST_GRP_ID = 0 THEN
OPEN P_CURSOR FOR
SELECT EVT_ID, EVT_ETD_ID, EVT_HST_ID, HST_NAME, SYS_ID, SYS_NAME,
EVT_TYPE, EVT_SMS,
EVT_CLASS, EVT_BEEPS, EVT_LEVEL,
TO_CHAR(EVT_DATE,'YYYY.MM.DD
HH24:MI:SS') EVT_DATE, EVT_STATE, EVT_MESSAGE
FROM
(
SELECT EVT_ID, EVT_ETD_ID, EVT_HST_ID, HST_NAME,
SYS_ID,
SYS_NAME, EVT_TYPE, EVT_SMS,
EVT_CLASS, EVT_BEEPS, EVT_LEVEL, EVT_DATE,
EVT_STATE,
EVT_MESSAGE
FROM MOA_EVENTS, MOA_HOST, MOA_SYSTEM, MOA_EVENT_USERS
WHERE EVT_HST_ID = HST_ID
AND HST_SYS_ID = SYS_ID
AND EVT_ETD_ID = EUS_ETD_ID
AND EUS_UGP_ID = P_UGP_ID
AND HST_VISIBLE = 1
AND SYS_ACTIVE = 1
AND SYS_VISIBLE = 1
-- AND EVT_DATE > sysdate - P_DAYS
ORDER BY EVT_ID DESC
)
WHERE ROWNUM <= 100;
RETURN ;
END IF;
IF P_HST_ID = 0 AND P_HST_GRP_ID > 0 THEN
OPEN P_CURSOR FOR
SELECT EVT_ID, EVT_ETD_ID, EVT_HST_ID, HST_NAME, SYS_ID, SYS_NAME,
EVT_TYPE, EVT_SMS,
EVT_CLASS, EVT_BEEPS, EVT_LEVEL,
TO_CHAR(EVT_DATE,'YYYY.MM.DD
HH24:MI:SS') EVT_DATE, EVT_STATE, EVT_MESSAGE
FROM
(
SELECT EVT_ID, EVT_ETD_ID, EVT_HST_ID, HST_NAME,
SYS_ID,
SYS_NAME, EVT_TYPE, EVT_SMS,
EVT_CLASS, EVT_BEEPS, EVT_LEVEL, EVT_DATE,
EVT_STATE,
EVT_MESSAGE
FROM MOA_EVENTS, MOA_HOST, MOA_SYSTEM, MOA_EVENT_USERS
WHERE EVT_HST_ID = HST_ID
AND HST_SYS_ID = SYS_ID
AND HST_GROUP = P_HST_GRP_ID
AND EVT_ETD_ID = EUS_ETD_ID
AND EUS_UGP_ID = P_UGP_ID
AND HST_VISIBLE = 1
AND EVT_DATE > SYSDATE - P_DAYS
AND SYS_ACTIVE = 1
AND SYS_VISIBLE = 1
ORDER BY EVT_ID DESC
)
WHERE ROWNUM <= 100;
RETURN ;
END IF;
IF P_HST_ID > 0 AND P_HST_GRP_ID = 0 THEN
OPEN P_CURSOR FOR
SELECT EVT_ID, EVT_ETD_ID, EVT_HST_ID, HST_NAME, SYS_ID, SYS_NAME,
EVT_TYPE, EVT_SMS,
EVT_CLASS, EVT_BEEPS, EVT_LEVEL,
TO_CHAR(EVT_DATE,'YYYY.MM.DD
HH24:MI:SS') EVT_DATE, EVT_STATE, EVT_MESSAGE
FROM MOA_EVENTS, MOA_HOST, MOA_SYSTEM, MOA_EVENT_USERS
WHERE EVT_HST_ID = HST_ID
AND HST_SYS_ID = SYS_ID
AND HST_ID = P_HST_ID
AND EVT_ETD_ID = EUS_ETD_ID
AND EUS_UGP_ID = P_UGP_ID
AND EVT_DATE > SYSDATE - P_DAYS
AND HST_VISIBLE = 1
AND SYS_ACTIVE = 1
AND SYS_VISIBLE = 1
ORDER BY EVT_ID DESC;
RETURN ;
END IF;
IF P_HST_ID > 0 AND P_HST_GRP_ID > 0 THEN
OPEN P_CURSOR FOR
SELECT EVT_ID, EVT_ETD_ID, EVT_HST_ID, HST_NAME, SYS_ID, SYS_NAME,
EVT_TYPE, EVT_SMS,
EVT_CLASS, EVT_BEEPS, EVT_LEVEL,
TO_CHAR(EVT_DATE,'YYYY.MM.DD
HH24:MI:SS') EVT_DATE, EVT_STATE, EVT_MESSAGE
FROM MOA_EVENTS, MOA_HOST, MOA_SYSTEM, MOA_EVENT_USERS
WHERE EVT_HST_ID = HST_ID
AND HST_SYS_ID = SYS_ID
AND HST_GROUP = P_HST_GRP_ID
AND EVT_HST_ID = P_HST_ID
AND EVT_ETD_ID = EUS_ETD_ID
AND EUS_UGP_ID = P_UGP_ID
AND EVT_DATE > SYSDATE - P_DAYS
AND HST_VISIBLE = 1
AND SYS_ACTIVE = 1
AND SYS_VISIBLE = 1
--AND EVT_ID >= (select max( EVT_ID ) from MOA_EVENTS) - 100
ORDER BY EVT_ID DESC;
RETURN ;
END IF;
P_ERR_CODE := 0;
P_ERR_DESC := 'OK';
EXCEPTION
WHEN NO_DATA_FOUND THEN
P_ERR_CODE := 10000;
P_ERR_DESC := 'Nie znaleziono danych';
MOA_LOG_PKG.SaveFatal( 'MOA_EVENT_PKG','GetEventList', SQLCODE,
P_ERR_CODE, P_ERR_DESC );
WHEN OTHERS THEN
P_ERR_CODE := 10001;
P_ERR_DESC := 'Blad: ' || SQLCODE || ' ' || SQLERRM;
MOA_LOG_PKG.SaveFatal( 'MOA_EVENT_PKG','GetEventList', SQLCODE,
P_ERR_CODE, SQLERRM );
END;
------------------------------------------------------------------------
[2005-02-11 21:19:36] [EMAIL PROTECTED]
Any info on how to reproduce it?
Your reproduce code is fairly senseless, as I don't have your packages
with your stored procedures.
------------------------------------------------------------------------
[2005-01-25 21:49:19] Tomasz dot Fryc at bph dot pl
Description:
------------
Database (Oracle 9.2.0.5.0 on HP-UX 11.11) connection is opened with
oci_new_connect function. A statment is prepared with oci_parse and a
cursor is created with oci_new_cursor. After binding the statement to
the cursor (oci_bind_by_name), the statement and the cursor are
executed (oci_execute). The problem occures while invoking
oci_fetch_all function, which sometimes doesn't give expected number of
rows (not all of the rows are fetched) and causes "ORA-01001: invalid
cursor" warning.
Reproduce code:
---------------
$sql="begin EXM.MY_PKG.getrows('param1','param2'); end;"
$conn=oci_new_connect("somebody","something")
$curs=oci_new_cursor($conn)
$stmt=oci_parse($conn,$sql)
oci_bind_by_name($stmt,"data",$curs,-1,OCI_B_CURSOR)
oci_execute($stmt,OCI_DEFAULT)
oci_execute($curs,OCI_DEFAULT)
$nrows=oci_fetch_all($curs,$results)
oci_free_statement($curs)
oci_free_statement($curs)
Expected result:
----------------
Every function is correctly executed except oci_fetch_all, which
sometimes doesn't give all of the rows.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=31693&edit=1
