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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
