Skip to Content

Rollback transactions and Stored Procedures

Jun 22, 2017 at 08:23 AM


avatar image

Hi. Have anyone else noticed (or is is me that is wrong) that HANA transaction can't rollback create and drop of stored proceures. Example. If you create a Store procedure and call it "MyProcedure" Then run the following SQL in the console of HANA Studio: SET TRANSACTION; DROP PROCEDURE "MyProcedure"; ROLLBACK; I would have imagined that after running this the procedure should still be there but it is not... Bug or Am i doing something wrong?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jun 22, 2017 at 08:46 AM

Hi Rasmus,

All DDL statements (Create,Drop etc) are Rollback-proof, I mean you can not rollback against a fired DDL statement, because an automatic implicit commit gets fired after a successful DDL statement.

And It's same for almost all DB vendors.(except PostgreSQL)

10 |10000 characters needed characters left characters exceeded