Select and update

Hello

I have a stored procedure that returns data and updates a table. How should I execute it to retrieve all the rows it returns and ensure that the changes are saved in the database?

Thank you