Oracle connection suddenly stopped working

From: Date: Thu, 08 May 2003 18:39:17 +0000
Subject: Oracle connection suddenly stopped working
Groups: php.general 
Request: Send a blank email to php-general+get-146897@lists.php.net to get a copy of this message
I've been running a PHP app which connects to a remote Oracle 8i server for several months. The app runs on Windows2000 running IIS. I'm using ADODB as the database abstraction layer and everything has been working flawlessly -- until today. Suddenly queries stopped returning valid recordsets. I turned on debugging (in ADODB) and get this... 1858: ORA-01858: a non-numeric character was found where a numeric was expected The app uses very basic select queries against a single view in Oracle. The Oracle DBA says nothing changed on their end other than the addition of a number of records, and I can't think of anything that changed on our end. We also have a ColdFusion app (using the native Oracle datasource) on the same server which is still working fine. Anyone run into anything like this before? Could the addition of new rows into the database have caused this. Is there a size limit on the number of rows returned? Thanks for any insight. -- Jack Baty Fusionary Media - http://www.fusionary.com/ for life is not a paragraph, and death i think is no parenthesis. -e.e. cummings

« previous php.general (#146897) next »