Re: uncomitted data gets committed when application dies

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 9 Dec 2004 16:42:02 +0100
Message-ID: <cp9roa$hb3$1@nntp.fujitsu-siemens.com>

"Volker Hetzer" <volker.hetzer_at_ieee.org> schrieb im Newsbeitrag news:cp7ekh$3qe$1_at_nntp.fujitsu-siemens.com...
>
> <yong321_at_yahoo.com> schrieb im Newsbeitrag news:1102527709.194220.232000_at_z14g2000cwz.googlegroups.com...
> > Can you try creating a logoff trigger:
> >
> > create or replace trigger t
> > before logoff on database
> > begin
> > rollback;
> > end;
> > /
> Sounds great! That's what I'll test next. This as the first command in the session
> ought to do the trick.

Tries that, only as a schema trigger (before logoff on schema). ORA-00600 during each sqlplus logoff. :-((

Lots of Greetings!
Volker Received on Thu Dec 09 2004 - 09:42:02 CST