Truncate table with a stored procedure in Mariadb

Question

I need to truncate a table with a stored procedure. Here is the code for the stored procedure:

DELIMITER //
CREATE PROCEDURE MA_ClearPenaltyExport

BEGIN

   TRUNCATE TABLE MA_STG_PenaltyExport;
    
END //
DELIMITER ;

but I'm getting an error as #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BEGIN

   TRUNCATE TABLE MA_STG_PenaltyExport;
    
END' at line 3

Answer 1

DELIMITER $$ 
CREATE OR REPLACE DEFINER=dbadmin@% PROCEDURE MA_ClearPenaltyExport( ) 
BEGIN 
TRUNCATE MA_STG_PenaltyExport; 
END$$
 DELIMITER ;

Answer 2

A its a single statement in the procedure the following also works:

CREATE PROCEDURE MA_ClearPenaltyExport()
TRUNCATE TABLE MA_STG_PenaltyExport;