Stored procedure calls

Oracle® MySQL and MariaDB implement stored procedures and stored functions as a collection of SQL statements that can take and return user-supplied parameters Functions are very similar to procedures, except that they return a scalar value and can be used in SQL expressions.

To create a stored procedure in a Oracle MySQL or MariaDB database, use the CREATE PROCEDURE statement. See reference documentation for more details.