c#调用存储过程 参数个数或数据类型出错!!!!急!急
存储过程段:
PROCEDURE GetMonitorGroup(p_shift_area varchar2, p_plant_name varchar2, p_eq_name varchar2,
p_target_type varchar2, p_start_date date, p_end_date date,
p_group_by varchar2, MonitorGroup in out cursor_MonitorGroup);
C#代码段:
cmd.Parameters.Add( "p_shift_area ", OracleType.VarChar).Value= "化一厂 ";
cmd.Parameters[ "p_shift_area "].Direction = ParameterDirection.Input;
cmd.Parameters.Add( "p_plant_name ", OracleType.VarChar);
cmd.Parameters[ "p_plant_name "].Direction = ParameterDirection.Input;
cmd.Parameters.Add( "p_eq_name ", OracleType.VarChar);
cmd.Parameters[ "p_eq_name "].Direction = ParameterDirection.Input;
cmd.Parameters.Add( "p_target_type ", OracleType.VarChar);
cmd.Parameters[ "p_target_type "].Direction = ParameterDirection.Input;
cmd.Parameters.Add( "p_start_date ", OracleType.DateTime);
cmd.Parameters[ "p_start_date "].Direction = ParameterDirection.Input;
cmd.Parameters.Add( "p_end_date ", OracleType.DateTime);
cmd.Parameters[ "p_end_date "].Direction = ParameterDirection.Input;
cmd.Parameters.Add( "p_group_by ", OracleType.VarChar);
cmd.Parameters[ "p_group_by "].Direction = ParameterDirection.Input;
cmd.Parameters.Add( "MonitorGroup ", OracleType.Cursor);
cmd.Parameters[ "MonitorGroup "].Direction = ParameterDirection.Output;
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
执行到da.Fill(ds);时就出现错误:
ORA-06550: 第