Returning an Oracle Data Set using Enterprise Library 2.0 - Part 2
If you need to return multiple tables in a data set from Oracle with then enterprise library, you have to specify the output parameters of the type OracleType.Cursor with a ParameterDirection.Output and with the specific name of the reference cursor. Then DAAB will check to see if there are cursor types attached to the database command and then not add its own because one or more already exists. Thus, when it goes to execute the LoadDataSet method, it should create a data table for each cursor output variable from Oracle.
