Re: Help!!! End of file!!!!!!!!! communication!!!!!!!!

From: Fred Hirschfeld <johndoe_at_microsoft.com>
Date: 1997/10/11
Message-ID: <61n8oe$6ei$1@news.bc>#1/1

The end-of-file on communication error is a nasty message as it can mean anything.

We had this happening on Oracle 7.3.2 using the Web Server and restarting the Listener would clear up the problem for several hours, and then running various stored procedures would cause the database to give this message and sometimes crash.

I think we had tracked this down to using CHAR fields in the database and then using various queries using straight SQL, cursors, and Dynamic SQL. When we changed the CHARs to VARCHAR2s and rebuilt the database. This seemed to work.

If you are using the Web Server, we also had a problem like this when the Web Server user was not a DBA for some reason???

Cheers Fred

Fred Hirschfeld                                      Sierra Systems
Consultants Inc
fhirsch_at_rogers.wave.ca                          Vancouver, BC (604)688-1371

http://www.sierrasys.com/ Received on Sat Oct 11 1997 - 00:00:00 CDT