OracleParameter[] ps = new OracleParameter[]{new OracleParameter("v_flowid",OracleType.VarChar,2,ParameterDirection.Input,true,0,0,"",DataRowVersion.Default,m_DBNull),
new System.Data.OracleClient.OracleParameter("V_CURSOR", System.Data.OracleClient.OracleType.Cursor, 255, System.Data.ParameterDirection.Output, true, 0, 0, "", System.Data.DataRowVersion.Default, this.m_DBNull)};
ps[0].Value = v_flowid;
try
{
ds = BLL.OracleHelper.ExecuteDataset(this.m_connectionString, System.Data.CommandType.StoredProcedure, "scott.GETYHLIST", ps);
}
调用oracle存储过程,报错 24338 未执行语句句柄CREATE OR REPLACE PROCEDURE GETYHLIST(v_flowid INTEGER,v_cursor OUT sys_refcursor)
IS
v_count NUMBER;
BEGIN
SELECT COUNT(*)
INTO v_count
FROM yh_flowdetail
WHERE yhflowid <> 3;
IF v_count > 0 THEN
OPEN v_cursor FOR
SELECT yfl.yhid,
yfl.title,
yfl.createtime,
yf.flowname,
ylr.layername,
yr.regionname,
yfl.cleartime,
yfl.yhdescribe
FROM yh_flowdetail yfl,
yh_flowname yf,
yh_layer ylr,
yh_level yll,
yh_region yr
WHERE 1 = 1
AND yfl.yhflowid = yf.flowid(+)
AND yfl.regionid = yr.regionid(+)
AND yfl.yhlayerid = ylr.layerid(+)
AND yfl.yhleverid = yll.levelid(+)
AND yfl.yhflowid = v_flowid;
RETURN;
END IF;
END;
数据库能够连上,但是执行的时候,就报错了。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货