DevOps, CI/CD and Automation

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!

Reports 6i to 10g Migration (Value Does Not Match mask 'MM/DD/YYYY'

Data BoyJan 28 2009 — edited Feb 4 2009

Dear all,

I am Migrating Oracle 6i Reports to 10g. I am just compiling the 6i Reports in 10g Reports Builder and giving the
Report for Deployment after it got successfully ran in the report builder.

In one of the Report Report Query i am checking date range like below

WHERE lov_dte BETWEEN :L_FRM_DTE AND :L_TO_DTE

L_FRM_DTE and L_TO_DTE input mask is MM/DD/YYYY

i got the output in report builder and as well as from the application also but after the compiled the same report
in 10g and tested in server ..

i am getting the following error in server ..

REP-546:Value does not match mask 'MM/DD/YYYY'
ORA-01030:Date format picture ends before converting entire input string

REP-0091:Invalid value for parameter L_FRM_DTE

any body faced the same problem ...please help me to resolve this issue ..

I Tried Changing the Query to

WHERE lov_dte BETWEEN to_date(:L_FRM_DTE,'mm/dd/yyyy') AND to_date(:L_TO_DTE,'mm/dd/yyyy')

but still no use because iam getting runtime error ORA-01858 NON NUMERIC CHARACTER WAS FOUND WHERE A NUMERICA CHAR WAS EXPECTED.

Thank you all for Looking into my problem..

Data Boy