How to call a stored procedure in MyBatis?

MyBatis provides several ways to call stored procedures, depending on the type of database and the stored procedure being used.

1. Invoke a stored procedure using the select statement.
2. 
   {call procedure_name(#{param1, direction=IN}, #{param2, direction=INOUT})}
   
3. The parameter is indicated as input when mode=IN, and as input and output when mode=INOUT.
4. Call stored procedures using insert, update, and delete statements.
5. 
   {call procedure_name(#{param1, input}, #{param2, inputOutput})}
   
6. Invoke a stored procedure using a stored procedure statement.
7. Execute the given procedure with the specified input and input/output parameters.

In the example above, procedure_name is the name of the stored procedure, and param1 and param2 are the parameters of the stored procedure. mode=IN is used to specify the input mode of the parameters, while mode=INOUT is used to specify the input/output mode of the parameters.

When calling a stored procedure, you can use the #{} placeholder to specify the value of the parameters. For example, #{param1} represents the value of parameter param1.

Furthermore, you can use #{result, mode=OUT, jdbcType=INTEGER} to retrieve the output parameter value of the stored procedure. Here, result is the name of the output parameter, mode=OUT indicates that the parameter is an output parameter, and jdbcType=INTEGER specifies that the parameter is of integer type.