> The tool Im using is "sqlplus". By default you are always in a transaction and > auto-commit only occur on exit. Its been a while since I worked with oracle. I remember I use to add the following two lines at the top: SET AUTOCOMMIT OFF whenever SQLERROR EXIT ROLLBACK IIRC, adding the above ensures that at the first error, oracle will rollback all changes , unless you add a DDL in the transaction which auto commits all changes.
