{"ORA-01008: 并非所有变量都已绑定"}

Question

******************ExecuteSqlDataSet()*************************


****************Createcommand()如下**************************************

下面的方法；没有发现错误，上面的da=new oracledataAdapter(cmd);
出现了，错误，参数有， proName,prams ，都有值。prams里面有一个参数，值是有的。

---

public DataSet Selectdata(string Order_number)
{

      string str =@"select VEH_PLATE_NUMBER,VEH_PLATE_COLOR,VEH_TYPE,VEH_BRAND_CODE from WEB_BOOKED_VEHICLES  where Order_NO=:ORDERNO";
       OracleParameter []prara = new OracleParameter[]
       {
        new OracleParameter(":ORDERNO",Order_number)
      };

       return oracleHelper.ExecuteProcDataSet(str,prara);
   }

Answer 1

OracleParameter[] prara = new OracleParameter[]{
new OracleParameter(":ORDERNO",OracleType.VarChar,50)
};
param[0].Value = Order_number;