5 Replies Latest reply on Oct 24, 2013 11:13 AM by Vishal Pathak (OBIEE-APEX)

    Invalid Number For Set Value

    Saumyadip Sarkar-Oracle



      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?