Re: ODBC produces logoff event?
Date: 21 Dec 2003 16:53:19 -0800
Message-ID: <233b7a65.0312211653.542aa53c_at_posting.google.com>
puppet_sock_at_hotmail.com wrote in message news:<c7976c46.0312181439.762b6fe7_at_posting.google.com>...
> Does the breaking of an ODBC connection produce a logoff event?
> I can't seem to get it to.
Are you talking about a normal or an abnormal connection closure (i.e. are you programmatically closing the connection or are you simulating an application crash by pulling the cable?
> What I was hoping was to use a trigger to do automatic cleanup
> of session specific data. But the closing of the ODBC does not
> fire the logoff trigger, even though closing sqlplus does.
What sort of session-specific data are you cleaning up? Unless you're doing something odd, session-specific data should be cleaned up by Oracle automatically when the Oracle session is terminated.
> Is there something I'm missing here? Is there a better way to
> cleanup session specific data when connecting through ODBC?
> I'm concerned with the case where the other end (a VB app)
> gets abnormally terminated.
Oracle will eventually notice that the client application has died and close the session in this case...
Justin Cave Received on Mon Dec 22 2003 - 01:53:19 CET