Oracle存储过程参数问题

Question

  db.MakeInParam("pv_plan_date1",OleDbType.VarChar,200,plan_date1),
  db.MakeInParam("pv_plan_date2",OleDbType.VarChar,200,plan_date2),
  db.MakeInParam("pv_dept_no",OleDbType.VarChar,2000,dept_no==""?OracleString.Empty:dept_no),
  db.MakeInParam("pv_style_no_list",OleDbType.VarChar,2000,style_no_list==""?OracleString.Empty:style_no_list)产生"对象必须实现 IConvertible"的错误,请问第三,四个参数这样设对不对,字符串为空时怎么设?

Answer 1

直接给db.MakeInParam("pv_dept_no",OleDbType.VarChar,2000,dept_no),
db.MakeInParam("pv_style_no_list",OleDbType.VarChar,2000,style_no_list)
有错?

Answer 2

to:copall(<民工>席卷天下-包举宇内-囊括四海-并吞八荒!) 这样执行不会有错,但结果有错,""与null是不一样的,当字符串为""时,应转为NULL,怎么传字符串的NULL值到ORACLE存储过程参数里边