Having issue while running a report from OIC using ATPDB table having date parameter
Hello,
I am attempting to run a scheduled integration that executes an SQL query with a date input parameter. I am currently providing the date in the "YYYY-MM-DD" format; however, I am encountering the following error:
"Pure SQL Exception; Caused by java.sql.SQLDataException: ORA-01861: literal does not match format string."
Could you please advise on the correct way to format or pass the date parameter to resolve this issue?
Thank you in advance for your assistance.
Tagged:
0