Skip to Content
0
May 30, 2018 at 07:27 AM

COMMIT IN HANA PROCEDURE

881 Views Last edit May 30, 2018 at 10:41 AM 2 rev

Hi Experts,

  CREATE PROCEDURE "KABIL_PRACTICE"."TEST_EXEC"
   AS BEGIN
   EXECUTE IMMEDIATE 'TRUNCATE TABLE "KABIL_PRACTICE"."EMP_PC"';
   EXEC 'COMMIT';
 END;

i created a procedure using the above code.but when i call that procedure it throw an error like as shown as below:

cannot perform truncate statement when auto commit is off.

in my property window the auto commit is in on only:

any help...

thanks in advance