Oracle-style packages were introduced in MariaDB 10.3.5.
 
Syntax
------ 
SHOW PACKAGE STATUS
 [LIKE 'pattern' | WHERE expr]
 
Description
----------- 
The SHOW PACKAGE STATUS statement returns characteristics of
stored package specifications, such as the database, name,
type, creator, creation and modification dates, and
character set information. A similar statement, SHOW PACKAGE
BODY STATUS, displays information about stored package
bodies (i.e. implementations).
 
The LIKE clause, if present, indicates which package names
to match. The WHERE and LIKE clauses can be given to select
rows using more general conditions, as discussed in Extended
SHOW.
 
The ROUTINES table in the INFORMATION_SCHEMA database
contains more detailed information.
 
Examples
-------- 
SHOW PACKAGE STATUS LIKE 'pkg1'\G
*************************** 1. row
***************************
 Db: test
 Name: pkg1
 Type: PACKAGE
 Definer: root@localhost
 Modified: 2018-02-27 14:38:15
 Created: 2018-02-27 14:38:15
 Security_type: DEFINER
 Comment: This is my first package
character_set_client: utf8
collation_connection: utf8_general_ci
 Database Collation: latin1_swedish_ci
 


URL: https://mariadb.com/kb/en/show-package-status/