This discussion is archived
6 Replies Latest reply: Nov 20, 2012 1:50 AM by 970816 RSS

ora-00932 inconsistent data type expected date got number

970816 Newbie
Currently Being Moderated
Hi all,

I have got an error ora-00932 inconsistent data type expected date got number in the below part of query.


NVL (TRUNC (wdj.date_completed), '14-NOV-2012')
BETWEEN NVL (TRUNC(:p_wo_completion_date_from),
NVL (TRUNC(wdj.date_completed), '14-NOV-2012')
)
AND TRUNC(:p_wo_completion_date_to)

can u please help me to resolve the error mentioned.

Thanks in advance.

Regards,
Ravi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points