Suppose that you have a stored procedure that performs several
separate select statements. Is there any way to create a stored
procedure that captures the output of the stored procedures in a
single blob of text, maybe into a variable that had been declared as a
varchar or as type text?

The reason I ask is because I am trying to cache the results of the
certain stored procedures. The first time that a particular stored
procedure is called, its results are cached to a table that contains a
single column of type "text".