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!

Date literal is not working in 12c

3317624Jul 19 2017 — edited Jul 20 2017

Dear Experts,

We have migrated our database from 11g to 12c. We have some dynamic query in which date literal is been passed as INPUT to a procedure.

In 11g it was working fine with out TO_DATE function but in 12c we are getting ORA-00932:Inconsistent data types:Expected date got number issue.

Below is the NLS date format of our DB.

NLS_CALENDAR                                                   GREGORIAN
NLS_DATE_FORMAT                                          DD-MON-RR
NLS_DATE_LANGUAGE                                     AMERICAN
NLS_CHARACTERSET                                          WE8ISO8859P1
NLS_SORT                                                         BINARY
NLS_TIME_FORMAT                                           HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                            DD-MON-RR HH.MI.SSXFF AM

Input format to the Procedure from UI:'07/14/2017 12:00:00 AM'

Please help me that why I couldn't execute the existing procedure in 12c which was working fine in 11g with out TO_DATE.

Thanks

Archana

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2017

Added on Jul 19 2017

33 comments

1,138 views