使用C# 操作Oracle存储过程记录集

命名空间：
    System.Data.OracleClient

C#连接Oracle字符串：
    string constr = “user id=用户名;password=密码;Data Source=服务名“;

Oracle返回记录集存储过程：
    1.定义游标
        Type tablesCursor is ref Cursor;
    2.定义存储过程
        Create or Replace Procedure 存储过程名
        (pCursor out tablesCursor)
        is
        begin
            open pCursor for select * from tables;
        end 存储过程名；
 
C#调用存储过程
    OracleCommand oraCmd=new OracleCommand();
    oraCmd.CommandText=“存储过程名“;
    oraCmd.CommandType=CommandType.StoredProcedure;
    OracleParameter cursor = new OracleParameter("pCursor",OracleType.Cursor,2000,ParameterDirection.Output,true,0,0,"",DataRowVersion.Default,Convert.DBNull);
    oraCmd.Parameters.Add(cursor);

    oracleDataAdapter1.SelectCommand.Connection.Open();
   oracleDataAdapter1.Fill(dataSet1,"person");
   dataGrid1.DataSource=dataSet1.Tables["person"];
   //dataGrid1.DataMember=person;
   oracleDataAdapter1.SelectCommand.Connection.Close();