Skip to Content
0
Jun 22, 2017 at 08:19 AM

SAP HANA. Create and Drop Procedure ignore transactions?

314 Views

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?