hi, I have code which has the following structure. I am getting a set of rows using the first statement and then executing the individual statements which may be a bunch of inserts, creates or deletes or drops . I want to commit if everything works or rollback the entire thing if there is an individual error during the execution of one of the statements. The problem i am facing is when i have a group of inserts and a drop or create , if there is an error create or drop the inserts prior to it are commiting even though setAutoCommit(false) is set but it works fine if all of the statemnts are inserts . I appreciate your valuable suggestions. I am using oracle 9i.