Hi , with AutoCommit -> 0, I removed begin_work but the rollback at the end did not actually rollback anything, stored proc created records... but the records were only supposed to be kept if i committed.. but i rolled back, so i expect nothing to be committed to the disk...
i am essentially trying to execute a sp, lets say 100 times that writes some records to the database, and , only if all 100 times are successfull --- then commit, else rollback ...