命名空间:
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();