How is work commited inside Stor Proc ?

I want to do the following

stm 1;
stm 2;
...
...
...
stm X;
--------- commit work here ---
stm X+1
...
...


Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz