The procedure does not automatically commit when it returns. The calling program controls commit scope. For batch callers that commit every N rows, this is essential. Set this to YES only when the procedure must be an autonomous transaction.