Oracle-style packages were introduced in MariaDB 10.3.5.
 
Syntax
------ 
DROP PACKAGE BODY [IF EXISTS] [ db_name . ] package_name
 
Description
----------- 
The DROP PACKAGE BODY statement can be used when Oracle
SQL_MODE is set.
 
The DROP PACKAGE BODY statement drops the package body (i.e
the implementation), previously created using the CREATE
PACKAGE BODY statement.
 
Note, DROP PACKAGE BODY drops only the package
implementation, but does not drop the package specification.
Use DROP PACKAGE to drop the package entirely (i.e. both
implementation and specification).
 


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