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

******************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);
   }

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