Forum: Building VoltDB Applications

Post: Stored Procedure - atomicity ?

Stored Procedure - atomicity ?
Jan 10, 2013
Is a stored procedure atomic or individual voltExecuteSQL statements within it are ?
In other words, if I have several voltExecuteSQL in my stored procedure; does a failure of even a single of them imply no change was done by the stored procedure or earlier voltExecuteSQL in the stored procedure could have changed the database permanently ?

Jan 14, 2013
The transaction starts at the entry of the stored proc and terminates at the end of the proc. Any operations that occur within the proc are rolled-back in the event of an error.