Re: What constitutes a Transaction ?

Dave Young wrote:
> If I insert into 4 other tables (C,D,E and F which could have been done by 4
> different procedures nested from the original trigger on table B) and the
> insert on F fails (which there will be an exception routine for) will C,D and E
> be rollbacked ? Does the ON ERROR clause automatically consitute a rollback and
> if so from what point? From the entry into that particular procedure or from
> the beginning trigger ? What manual do I find these answers ?

  If the insertion on F fails, the insertions C, D and E will also rollback back.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841