DLL需要引用
Oracle.DataAccess.Client
System.Data string oraSql = "insert into ora_vssample values(:a,:b,:c,:d)";
oraCommand.Parameters.Add("a",OracleDbType.Varchar2,"100100",ParameterDirection.Input);
oraCommand.Parameters.Add("b", OracleDbType.Varchar2, "Pen", ParameterDirection.Input);
oraCommand.Parameters.Add("c", OracleDbType.Varchar2, "ORA1100", ParameterDirection.Input);
oraCommand.Parameters.Add("d", OracleDbType.Varchar2, "2", ParameterDirection.Input);
以这种方式成功执行insert into语句 但是同样的方式进行delete却行不通是为什么?
string oraSql = "delete from ora_vssample where ora_id=:paramId";
oraCommand.Parameters.Add("paramId",OracleDbType.Varchar2,"ORA1100",ParameterDirection.Input);求大神帮忙解答
Oracle.DataAccess.Client
System.Data string oraSql = "insert into ora_vssample values(:a,:b,:c,:d)";
oraCommand.Parameters.Add("a",OracleDbType.Varchar2,"100100",ParameterDirection.Input);
oraCommand.Parameters.Add("b", OracleDbType.Varchar2, "Pen", ParameterDirection.Input);
oraCommand.Parameters.Add("c", OracleDbType.Varchar2, "ORA1100", ParameterDirection.Input);
oraCommand.Parameters.Add("d", OracleDbType.Varchar2, "2", ParameterDirection.Input);
以这种方式成功执行insert into语句 但是同样的方式进行delete却行不通是为什么?
string oraSql = "delete from ora_vssample where ora_id=:paramId";
oraCommand.Parameters.Add("paramId",OracleDbType.Varchar2,"ORA1100",ParameterDirection.Input);求大神帮忙解答
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货