parameterized SQL script -

set echo on set verify on  accept cnumber char prompt 'customer number == ' accept pnumber char prompt 'part number == ' accept od date format 'yyyymmdd' prompt 'order date == '   delete orders cnum = &cnumber , pnum = &pnumber , orderdate = to_date(&od,'yyyymmdd');   prompt done.  --delete orders cnum = 'c111' , pnum = 'm001' , orderdate = to_date(20130401,'yyyymmdd');  

output:

sql> delete orders   2  cnum = &cnumber , pnum = &pnumber , orderdate = to_date(&od,'yyyymmdd'); old   2: cnum = &cnumber , pnum = &pnumber , orderdate = to_date(&od,'yyyymmdd') new   2: cnum = c111 , pnum = m001 , orderdate = to_date(20130404,'yyyymmdd') cnum = c111 , pnum = m001 , orderdate = to_date(20130404,'yyyymmdd')                              * error @ line 2: ora-00904: "m001": invalid identifier  

whats wrong??

cnum = '&cnumber' , pnum = '&pnumber'

not sure &od, need quote too?