the rows would not be available to see to other sesisons until a commit

the stored proc doesnt need to confirm anything, it just runs and finished when it is done