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/