Enterprise Library 2.0 关于存储过程返回记录集游标的解决方法示例代码

名称空间:using System.Data.OracleClient;

OracleDatabase dataBase = DatabaseFactory.CreateDatabase() as OracleDatabase;
            OracleCommand cmd = dataBase.GetStoredProcCommand("ProcName") as OracleCommand;
            //记录集游标参数的输入pcur
            dataBase.AddParameter(cmd, "pcur", OracleType.Cursor, 100, ParameterDirection.Output, true, byte.MaxValue, byte.MaxValue, String.Empty, DataRowVersion.Default, Convert.DBNull);
            dataBase.AddInParameter(cmd, "pevesselname", DbType.String, EVesselName);
            dataBase.AddInParameter(cmd, "pboundvoy", DbType.String, Voy);
            dataBase.AddInParameter(cmd, "pinout", DbType.String, inOutType);
            dataBase.AddOutParameter(cmd, "pflag", DbType.Int32, 10);
            cmd.Connection = dataBase.CreateConnection() as OracleConnection;
            cmd.Connection.Open();
            OracleDataAdapter da = new OracleDataAdapter(cmd);
            DataSet ds = new DataSet();           
            da.Fill(ds);
            return ds;