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

André Hartmann wrote:
> Hi there,
> I would like to simulate ORA-03114 in a test application and I would
> like to get some clues as to how to do this.
>
> Since people are probably going to ask why I want to do that, here is
> some background. An Oracle client application of ours that connects to
> Oracle via OCI, sometimes faces loss of connection, for example when a
> lap to goes into hibernation or the network is unstable. We are speaking
> of a Windows 2000, XP, Vista client here. Now we want to improve the
> error handling in our application in this specific case. That is no
> problem because ORA-03114 can be detected and appropriate measures can
> be taken (error message, automatic reconnection, ...).
>
> However for every issue that we fix in our applications we are writing
> a test case which will test a particular behaviour or bug fix. We do
> this in form of unit tests, so the unit test application will simply run
> for a short or long span of time without user interaction and protocol
> what happened, for example how many of the tests succeeded and how many
> failed.
>
> The loss of connection we dont know how to simulate. One way is to use
> OEM and manually KILL the session at the appropriate point of time and
> see what the application will do. But that requires user interaction, so
> its not like you can run the tests over night and just scan the protocol
> the next morning...
>
> We are using MS Dev studio 2005/2003 and the standard OCI library.
> Thanks very much in advance
>
> André
> :)

[Quoted] 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.

Trapping for a lack of connection will tell you nothing about why or how you got there. For that you need to use:

DBMS.UTILITY.FORMAT_ERROR_BACKTRACE
DBMS.UTILITY.FORMAT_CALL_STACK
DBMS.UTILITY.FORMAT_ERROR_STACK

Demos in Morgan's Library at www.psoug.org under DBMS_UTILITY.

If all you want to do is create a disconnection pull the CAT5 cable out of the back of a machine or use ALTER SYSTEM KILL SESSION: Demostrated in the Library under KILLING SESSIONS.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org