BEGIN WORK/COMIT WORK in stored procedure
Can a transaction be defined in a stored procedure.
Something like -
CREATE PROCEDURE a()
FOR EACH
BEGIN WORK
INSERT......
<more stuff>
COMMIT WORK
END FOREACH;
END PROCEDURE;
Thanks for any help...
Frank