How to store a recordset from TMSStoredProc?

[ilikegreentrafficlights]

Hi i'm new to using SDAC,
How do i store a recordset that is returned from a stored proc without using the ADO objects?

I.e. Old code snippet
lRecordSet : _RecordSet;

fADOStoredProc.ExecProc;
lRecordSet := fADOStoredProc.RecordSet;


I can return a single variable using this

MSStoredProc1.ExecProc;
lReturnID := MSStoredProc1.Params.ParamByName('@RETURN_VALUE').Value;

But how to store a recordset?
Thanks.

[Jackson]

TMSStoredProc is descendant of TDataSet and dataset returned by ExecProc method is placed in the TMSStoredProc object itself.