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!

Is COMMIT; required in Procedure body?

659873Sep 26 2008 — edited Feb 2 2009

Hi,

How should the COMMIT statement be used within a Procedure or Function? I saw in the Procedures, some developers end the DML statement with COMMIT; some never issue a COMMIT.

Can you please advise a good practice regarding the COMMIT statement?

Thanks in advance for any help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2009

Added on Sep 26 2008

7 comments

5,326 views