Friends

I am not sure of setting autocommit off in one of my stored prcedure.
Can any one help me .
I appreciate for any immediate help

have a look at this page
http://publib.boulder.ibm.com/infoce.../r0010308.html

I usually (but not always) do commits inside the stored procedure. One of the main benefits of a stored procedure is that it minimizes the elapsed time between multiple SQL statements (by running them back-to-back on the server). When I want to minimize the elapsed time of the Unit of Work, I commit as soon as possbile withiin the SP.

While Marcus has a good point, you should also think carefully about the context in which your SP may be called. A SP is called in a transaction/unit-of-work initiated by the caller, you will effectively commit the caller's transaction. That may be acceptable - or maybe not!