SQL & PL/SQL

The best is to commit the largest logical transaction you can.

Were I writing the code that would mean that the last line of the procedure would commit the work done by the procedure unless there was a compelling reason to do something else.

Incremental commits should never be done, except, again if there is a proven reason to do otherwise ---- could someone tell me on reason to do that? I want to show in a presentation a case where is important to do incremental commits...

Thanks a lot