There are 3 types of procedures in MariaDB database on the basis of references and parameter overwritten. These are
* IN procedure : In this type of procedure, the values of a parameter can be overwritten and referenced by the procedure.
* OUT procedure : In this type of procedure, the values of parameter can be overwritten by the procedure but it can’t be referenced by a procedure.
* IN OUT : In this type of procedure, the values of a parameter can be referenced by the procedure but it can’t be overwritten by a procedure.