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