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. |
© 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/