Stored procedure call with Oracle MySQL / MariaDB
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.