Can't you spot the typo when someone suggests something so trivial as in above, particualry when the error code says it so clearly?? Can't you use some plain common sense and try:

where full_date = to_date('11/30/2004','MM/DD/YYYY')