I am written the following code that will call oracle stored proc and the results are captured in a dataset.

In my new requirements, I need to call one more stored proc add the results from that procedure to the same dataset (may be a new table). so when I go thru this dataset I will have two datatables

How can add the results of the second stored proc to the same dataset (aDataSet)?

thanks

nath

OracleParameter ps1 = new OracleParameter("io_cursor", OracleType.Cursor);

ps1.Direction = ParameterDirection.Output;


OracleParameter[] param = { ps1 };

aDataSet = aDataBase.ExecuteDataSet("ReconcileHarmdm", param);

return aDataSet;