Forum: Building VoltDB Applications

Post: Stored Procedure - atomicity ?

Stored Procedure - atomicity ?
gambitg
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 ?

Thanks.
awilson
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.