ora error
| From: | Mark | Date: | Tue, 06 Feb 2001 13:52:24 +0000 |
| Subject: | ora error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-38385@lists.php.net to get a copy of this message | ||
I wrote a php script that queries for a paticular group of documents, gets
the path of the documents and copies them to a holding area. But there is
one problem I keep getting the following error about every 20th time the
script is executed.
Database error:
ora_parse() failed:
select DOCUMENT_ID docnum, ISSUE rev, VOLUME vol, SECTION, CHANGE, PATH,
SHEET FROM raois_sheets WHERE DOCUMENT_ID LIKE UPPER('tm-007-001%') ORDER BY
DOCUMENT_ID, ISSUE desc, SHEET
Snap & paste this to sqlplus!
Oracle Error: 2042 (ORA-02042: too many distributed transactions ORA-02063:
preceding line from SHEETS -- while processing OCI function OPARSE)
Session halted.
I can restart the web server and all is fine again but I want to and end to
this error once and for all.
Does anybody know what is causing this and/or how to fix it?
Thanks
Mark