I am trying to create a dynamic action for which under SQL Statement I have used the following code
select to_char(:P3_COMPLEX_INV_DATE,'MON') FROM DUAL where :P3_COMPLEX_INV_DATE is a date picker in DD-MM-YY format.
My requirement is to extract the month part from the date user has chosen.
I am getting the following error
Ajax call returned server error ORA-01722: invalid number for Set Value.
Can anyone help me solve the problem?