ora error

From: 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

« previous php.general (#38385) next »