26 Feb 2011

concurrent program auto commit

If the program completes successfully, it's retcode will be '0' and that session committed automatically i.e., you need not to put explicit commit in the PL/SQL procedure.If your PL/SQL procedure is being called from a concurrent program NO explicit commit is required. 

Which means you need not to put commit at the end of the procedure if your procedure is registered as concurrent program