transaction question

From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/09/12
Message-ID: <32386f72.27985605_at_n5.gbso.net>#1/1


If a statement fails due to the "rollback segment too small" error, won't that force the entire transaction to be rolled back?

Assume I do the following....

DELETE...
INSERT...

COMMIT; If the INSERT fails, won't that rollback the DELETE too? And then COMMIT an empty transaction?

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!
Received on Thu Sep 12 1996 - 00:00:00 CEST

Original text of this message