SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using Transactions in PL/SQL

390382Nov 28 2006 — edited Nov 30 2006

I have a package that does some inserts and updates. Now, I need the functionality of a transaction for my whole package such that if anything fails during execution of the procedures of the package, I can rollback all the changes or if there is no error, commit all the changes made by the package.Does PL/SQL has something similar to BEGIN TRANS-END TRANS block in SQL Server?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2006

Added on Nov 28 2006

6 comments

1,441 views