PL/SQL Block convert to HiRDB SQL Stored Procedure. Procedure_name is fixed name.

Oracle:

DECLARE
num NUMBER;
BEGIN
n :=1;
BEGIN
  n1 :=2;
END;
 n2 :=3;
END;

HiRDB:

CREATE PROCEDURE  pr_name()
BEGIN
 DECLARE num FLOAT;
 SET n = 1;
 BEGIN
    SET n1 = 2;
 END;
 SET n2 = 3;
 END;
END_PROC