1
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.
-
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
Shows the CREATE statement that creates the specific 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
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.
