6 Replies Latest reply: Nov 20, 2012 3:50 AM by 970816 RSS

    ora-00932 inconsistent data type expected date got number

    970816
      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