id INT) AS
 BEGIN
  raiseSalary(eid, stdRaiseAmount);
  log(eid, 'raiseSalaryStd id=' || eid);
 END;

BEGIN
 -- This code is executed when the current session
 -- accesses any of the package routines for the first time
 log(0, 'Session ' || connection_id() || ' ' || current_user || ' started');
END;
$$

DELIMITER ;

Non-Oracle mode, from MariaDB 11.4:

DELIMITER $$

CREATE OR REPLACE PACKAGE pkg
 PROCEDURE p1();
 FUNCTION f1() RETURNS INT;
END;

$$

DELIMITER ;

DELIMITER $$

CREATE OR REPLACE PACKAGE BODY pkg

-- variable declarations
 DECLARE a INT DEFAULT 11;
 DECLARE b INT DEFAULT 10;

-- routine declarations
 PROCEDURE p1()
 BEGIN
  SELECT CURRENT_USER;
 END;

FUNCTION f1() RETURNS INT
 BEGIN
  RETURN a;
 END;

-- package initialization section
 SET a=a-b;
END;
$$

DELIMITER ;

URL: https://mariadb.com/kb/en/create-package-body/https://mariadb.com/kb/en/create-package-body/