Re: transaction question

Chuck Hamilton wrote:
>
> 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!

if you are running this from sql*plus, be sure to have autocommit OFF

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)