There are four ways to return data from stored procedure.
There are three ways of returning data from a procedure to a calling program: result sets, output parameters, and return codes.