|RETURNS||Specifies the data type that can be returned from a function.|
|RETURN||Actual variable or value following the |
A stored routine is either a procedure or a function.
A procedure is invoked using a CALL statement and can only pass back values using output variables.
A function can be called from inside a statement just like any other function and can return a scalar value.