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 manager?
- Impact of making a stored program transactional while running u... David Karr
