SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-00932 inconsistent data type expected date got number

970816Nov 20 2012 — edited Nov 20 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2012

Added on Nov 20 2012

#data, #date

6 comments

1,348 views