Skip to Content

SAP HANA. Create and Drop Procedure ignore transactions?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 18 at 08:46 AM

    Hi Rasmus,

    Maybe I'm resurrecting an old thread, but in case if someone falls here: By default HANA server implicitly commits all DDL statements: ALTER/DROP/CREATE TABLE/PROCEDURE etc. To change this behaviour there is a session property "TRANSACTION AUTOCOMMIT DDL". If you set it to OFF you can handle these transactions yourself. More information in SAP HELP

    Add comment
    10|10000 characters needed characters exceeded