Similar with Oracle PL/SQL.

Test Table

CREATE TABLE TEST (
  A INTEGER,
  B TIMESTAMP
) 

Create Procedure

CREATE or replace PROCEDURE TESTP
 (IN VARA INTEGER)
  LANGUAGE SQL
  MODIFIES SQL DATA
BEGIN
  insert into TEST(a) values(VARA);
END

Call Procedure

call TESTP(123)