Stored Procedure to Capture Results via Script

I am curious if anyone has returned output from a stored procedure via script within a business process?  I found one process with a script task that uses the StoredProcedure object to execute the stored procedure, but nothing to capture the output.  Is this possible under the bpm online platform objects?

CalcForecastFactPotentialProcess

if (ForecastId != Guid.Empty) {

StoredProcedure storedProcedure = new StoredProcedure(UserConnection, "tsp_RecalculateForecastFact")

.WithParameter("ForecastId", ForecastId) as StoredProcedure;

storedProcedure.PackageName = UserConnection.DBEngine.SystemPackageName;

if (CurrentUserContactId != Guid.Empty) {

storedProcedure.WithParameter("CurrentUserContactId", CurrentUserContactId);

}

storedProcedure.Execute();

CreateReminding();

}

return true;

Using Reader

SqlConnection connection = new SqlConnection(ConnectionString);

command = new SqlCommand("TestProcedure", connection);

command.CommandType = System.Data.CommandType.StoredProcedure;

connection.Open();

reader = command.ExecuteReader();

List TestList = new List();

Test test;

while (reader.Read())

{

    test = new Test();

    test.ID = int.Parse(reader["ID"].ToString());

    test.Name = reader["Name"].ToString();

    TestList.Add(test);

}

Use DataTable

SqlConnection connection = new SqlConnection(ConnectionString);

command = new SqlCommand("TestProcedure", connection);

command.CommandType = System.Data.CommandType.StoredProcedure;

connection.Open();

DataTable dt = new DataTable();

dt.Load(command.ExecuteReader());

gvGrid.DataSource = dt;

gvGrid.DataBind();

Steve