执行存储过程
CREATE OR REPLACE PACKAGE HAIDAO3.GinkouKessan IS -- 创建包
type outList is ref cursor;
PROCEDURE GetOrderInfo(RESULT OUT outList); -- 返回一个结果集
END GinkouKessan;
/
CREATE OR REPLACE PACKAGE BODY HAIDAO3.GinkouKessan IS -- 创建包体
PROCEDURE GetOrderInfo (
RESULT OUT outList
) IS
BEGIN
OPEN RESULT
FOR
SELECT
…
FROM
…
WHERE
…;
END;
END GinkouKessan;
/
C#中:
string connStr = "……";
OracleConnection conn = new OracleConnection(connStr);
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "GinkouKessan.GetOrderInfo";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter("RESULT", OracleType.Cursor)).Direction = ParameterDirection.Output;
DataSet ds = new DataSet();
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
adapter.Fill(ds, "ORDER_INFO");
……
以上是一部分介绍,如需要完整的资料或者如不符合您的要求,请联系技术人员qq:242219979咨询