Skip to Main Content

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!

Commit in Package

FlakeDec 9 2009 — edited Dec 11 2009
Hi all,

I have a package with 20 procedures and functions. Each package/function has some update and insert statements. There is one procedure that gets called at the end which I call as pkg_final. To commit all the inserts/updates, is it enough that I put a commit at this procedure or should commit follow each inserts and updates at their own procedure/function?

I think all the inserts/updates in procedures and functions belonging to a package fall under a single transaction. Am I right?

Thanks,
Prajeeth
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2010
Added on Dec 9 2009
16 comments
2,963 views