| Re: Direct SQL Update in Agent. When is it committed?
Ian,
Thank you for your insight. It was just what I was looking for. I have inherited OTM Administration and would like to try to standardize some practices for agents, recurring processes etc. I would appreicate it if you could expand on the following:
Why no COMMITS or ROLLBACKS in the procedure?
Is there a problem using a cursor for loop? Whate are your reasons for only using EXPLICIT cursors? |