Oracle-style packages were introduced in MariaDB 10.3.5.
 
Syntax
------ 
DROP PACKAGE [IF EXISTS] [ db_name . ] package_name
 
Description
----------- 
The DROP PACKAGE statement can be used when Oracle SQL_MODE
is set.
 
The DROP PACKAGE statement drops a stored package entirely:
Drops the package specification (earlier created using the
CREATE PACKAGE statement).
Drops the package implementation, if the implementation was
already created using the CREATE PACKAGE BODY statement.
 


URL: https://mariadb.com/kb/en/drop-package/