Answer:
You can assign a value to a routine variable in any of the following ways:
Use a LET statement.
Use a SELECT INTO statement.
Use a CALL statement with a procedure that has a RETURNING clause.
Use an EXECUTE PROCEDURE INTO or EXECUTE FUNCTION INTO statement.
Explanation: