CREATE PACKAGE
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.3.5
Oracle-style packages were introduced in MariaDB 10.3.5.
Syntax
CREATE [ OR REPLACE] [DEFINER = { user | CURRENT_USER | role | CURRENT_ROLE }] PACKAGE [ IF NOT EXISTS ] package_name [ package_characteristic ... ] { AS | IS } [ package_specification_element ... ] END [ package_name ] package_characteristic: COMMENT='string' | SQL SECURITY { DEFINER | INVOKER } package_specification_element: FUNCTION_SYM package_specification_function ; | PROCEDURE_SYM package_specification_procedure ; package_specification_function: func_name [ ( func_param [, func_param]... ) ] RETURNS func_return_type [ package_routine_characteristic... ] package_specification_procedure: proc_name [ ( proc_param [, proc_param]... ) ] [ package_routine_characteristic... ] func_return_type: type func_param: param_name type proc_param: param_name { IN | OUT | INOUT | IN OUT } type type: Any valid MariaDB explicit or anchored data type package_routine_characteristic: COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER }
Contents
Description
The CREATE PACKAGE
statement can be used when Oracle SQL_MODE is set. It is used to create the specification for a stored package, or collection of objects
The objects are declared in the CREATE PACKAGE
statement, and later defined in the CREATE PACKAGE BODY
statement.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.