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