#Rails Call stored procedure and retrieve return value

stored_procedure.rb

class StoredProcedure
  def self.return_value name, *args
    ActiveRecord::Base.connection_pool.with_connection do |connection|
      args = args.map{|e| connection.quote e}
      output = connection.select_all("Declare @status int;" + 
        "EXEC @status = #{name} #{args.join(',')};" +
        "select @status as status;")
      return_value = Hash[*output]
      return_value["status"]
    end
  end
end