create or replace
PROCEDURE p_PT_ALMDIGITALCONFIG_C
(
a_TAGNAME IN VARCHAR2 ,
a_ALMDESCR IN NVARCHAR2 ,
a_ALARMPRIORITY IN NVARCHAR2 ,
a_ALARMGROUPID IN NVARCHAR2 ,
a_REMARK IN NVARCHAR2 ,
a_ALMVALUE OUT NUMBER
)
AS
BEGIN
INSERT INTO TPRI.T_PT_ALMDIGITALCONFIG (
TAGNAME,
ALMDESCR,
ALARMPRIORITY,
ALARMGROUPID,
REMARK
)
VALUES (
a_TAGNAME,
a_ALMDESCR,
a_ALARMPRIORITY,
a_ALARMGROUPID,
a_REMARK
);
END p_PT_ALMDIGITALCONFIG_C;
--endregio
这是存储过程
这是执行方法
/// <summary>
/// Insert a new t_points_almdigitalconfigs record to database.
/// </summary>
/// <param name="t_Points_ALMDigitalConfigsInfo"></param>
/// <returns></returns>
public int add(T_Points_ALMDigitalConfigs t_Points_ALMDigitalConfigsInfo)
{
OracleParameter[] parms = new OracleParameter[6];
parms[0] = new OracleParameter("a_TagName", t_Points_ALMDigitalConfigsInfo.TagName);
parms[1] = new OracleParameter("a_ALMDESCR", t_Points_ALMDigitalConfigsInfo.ALMDESCR);
parms[2] = new OracleParameter("a_AlarmPriority", t_Points_ALMDigitalConfigsInfo.AlarmPriority);
parms[3] = new OracleParameter("a_AlarmGroupID", t_Points_ALMDigitalConfigsInfo.AlarmGroupID);
parms[4] = new OracleParameter("a_Remark", t_Points_ALMDigitalConfigsInfo.Remark);
parms[5] = new OracleParameter("a_ALMValue", OracleDbType.RefCursor);
parms[5].Direction = ParameterDirection.Output;
return dal.ExecuteNonQuery(CommandType.StoredProcedure, "TPRI.P_PT_ALMDIGITALCONFIG_C", parms);
}
这是报出来的错误