returning multiple result sets
388254Feb 20 2003 — edited Oct 20 2005I would like to populate multiple tables in a typed
DataSet in a single call to OracleDataAdapter.Fill
(one round trip to the database). I have found examples
that do this with REF CURSOR output parameters from a
stored procedure that is defined in a package. However,
my SELECT statements are dynamically generated. Is there
any way to execute multiple dynamic SELECT statements in
a single Command used by OracleDataAdapter.Fill? Or is
there some other way to do this with dynamic SQL?
Thanks,
Dennis
dennis_mccarthy@onesource.com