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
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