W3cubDocs

/MariaDB

Stored Procedures

A stored procedure is a routine invoked with a CALL statement. It may have input parameters, output parameters and parameters that are both input parameters and output parameters.

Title	Description
Stored Procedure Overview	A Stored Procedure is a routine invoked with a CALL statement.
Stored Routine Privileges	Privileges associated with stored functions and stored procedures.
CREATE PROCEDURE	Creates a stored procedure.
ALTER PROCEDURE	Change stored procedure characteristics.
DROP PROCEDURE	Drop stored procedure.
SHOW CREATE PROCEDURE	Returns the string used for creating a stored procedure.
SHOW PROCEDURE CODE	Display internal implementation of a stored procedure.
SHOW PROCEDURE STATUS	Stored procedure characteristics.
Binary Logging of Stored Routines	Stored routines require extra consideration when binary logging.
Information Schema ROUTINES Table	Stored procedures and stored functions information
SQL_MODE=ORACLE From MariaDB 10.3	MariaDB understands a subset of Oracle's PL/SQL language.
Stored Procedure Internals	Internal implementation of MariaDB stored procedures.

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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/stored-procedures/