David Karr wrote:
it's supposedly good advice in a multi-step stored procedure to have an
explicit "start transaction" and "commit" wrapping the work. What is the
impact of doing this if the stored procedure is called from code managed by
a transaction manager. For instance, in a JEE appserver
it's supposedly good advice in a multi-step stored procedure to have an
explicit "start transaction" and "commit" wrapping the work. What is the
impact of doing this if the stored procedure is called from code managed by
a transaction manager. For instance, in a JEE appserver and a transaction
ma