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

    Invalid Number For Set Value

    Saumyadip Sarkar-Oracle

      Hi

       

      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?