Re: How to simulate ORA-03114 "Not connected to Oracle" in a test

André Hartmann wrote:
> "DA Morgan" <damorgan@[EMAIL PROTECTED]
> schrieb im Newsbeitrag 
> news:1194616637.115847@[EMAIL PROTECTED]
>> Some Oracle error messages for example, ORA-03114 not connected to 
>> ORACLE, are not root causes but rather the result of something else.
>> A session might be disconnected for hundreds of reasons.
> 
> 
> Yes, I know that. I am not aiming at tracking down the reason here, I am

> aiming at testing the application code, that reacts to the occurrence of

> the event. For example the reaction could be to establish a new 
> connection to the schema and continue as normal.

But the application code is meaningless for this error message. Is the
cause of the disconnect that the Oracle client had a brain hemmorhage?
Or that the CAT5 cable is disconnected? Or the fact that someone on the
server did SHUTDOWN ABORT? You don't know. You can not know. And there
is nothing your application can do about it except keep trying to
reconnect for some finite period before timing out.
-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Wa****ngton
damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org