To commit or not to commit - That is the question?

From: Ian Quennell <ian.quennell_at_handc.com>
Date: 1997/09/09
Message-ID: <01bcbd3e$23cb9da0$c69d73c1_at_QRPIQ.handc.com>#1/1


Help.

[Quoted] [Quoted] I have a number of SQL*Plus procedures which need to run in sequence. These procedures validate and load data in tables and place any validation failures in an error table.

However, if, for example the third procedure fails all procedures must be rolled back.
This is fine except that the validation failures are then rolled back as well.

Any ideas on how it is possible to keep these failures

Thanks

Ian Q Received on Tue Sep 09 1997 - 00:00:00 CEST

Original text of this message