Commit Stored Procedures
717025Aug 18 2010 — edited Aug 18 2010Hello everybody,
I'm writing a package of a Web application. Is it necessary to commit/rollback in the Insert/Updates statements ?
Ex:
INSERT INTO t1 VALUES(1);
EXCEPTION
-- exception handling
IF success THEN COMMIT ELSE ROLLBACK;