I hope somebody can help me with these errors.  Sorry for
cross-posting to non-Delphi news groups but I'm at a loss to why this
is happening.

I have a Delphi 4.0 client (with the latest updates including BDE
5.10) communicating with Oracle 8i.  Everything was fine up until
today. :(  Then I came in and our tester showed me the following
messages coming up on his screen.

===================================================================
"Lost communication with SQL server.  ORA-03113: end-of-file on
communication channel."

followed by

"General SQL Error.  ORA-01041: internal error.  hostdef extension
doesn't exist."
===================================================================

At first, I thought it must be something with his config.  So I tested
it on my machine.  And guess what, I have exactly the same problem. :(

The program was using a stored procedure to return a ref cursor from a
view.  That was pretty slow, so I spent most of the day converting it
to query the tables directly by creating the SQL dynamically at the
Delphi.  Still no go!

I then tried running the SQL for the original view (which is big and
has 4 unions) and got the same error.

Please email & post any suggestions as I'd like to fix this ASAP!
Email will get to me quicker.

Thanks in advance,

This is most likely a bug. The server should not be crashing. Contact Oracle
Support. They should be able to help you figure out what's going on.

                                   Rick

Thanks Rick,

I will be giving Oracle a call.  I have 3 servers with the same
database structure, same version of Oracle but the problem server is
running SunOS 5.7 while the others are running SunOs 5.6.  The problem
server also has the least amount of data.

I'd be most interested in finding out what causes these problems ! Let
me know if your side of Oracle can give you any clue what to do!