MariaDB starting with 10.3.5
----------------------------
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/