Re: transactions over multi-table insert

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Tue, 28 Aug 2001 23:58:12 GMT
Message-ID: <oeWi7.443081$p33.8502061@news1.sttls1.wa.home.com>

commit;
insert into table1...;
insert into table2....;
If you get an error then:
rollback;
if not then commit;

Transactions are not table specific.

Jim
"christopher lambert" <cjlambert_at_llnl.gov> wrote in message news:1932d1c8.0108281524.6eebe992_at_posting.google.com...
> how can I perform a transaction-like operation over several inserts
> operating on different tables? (e.g. if I've inserted to table1 and
> then an insert to table2 fails, I want to rollback table1)
Received on Tue Aug 28 2001 - 18:58:12 CDT