TheGreenOne
Programmer
In ASA 9, I have created a database User Event which calls a stored procedure, the event is triggered manually. The stored procedure has a loop which creates lots of new records. Within the loop it commits the changes. I read somewhere that if any error occurs in an event all changes are rolled back. It would not be possible to rollback if the stored procedure explicitly commits, would it? Could it be that commits are ignored when a stored procedure is call by an event?
All comments welcome, thanks in advance.
All comments welcome, thanks in advance.