⬅ 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.