Skip to Content
0

SAP HANA. Create and Drop Procedure ignore transactions?

Jun 22, 2017 at 08:19 AM

38

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.

0 Answers