5 Replies Latest reply on Sep 14, 2016 4:51 PM by rp0428

    SQLdeveloper 4.1.3 Unittesting validation query reports date expected, get a number

    3031071

      I created a unit test for a function with date parameters. The validation queries should use these date parameter values.

      However an error message is given that a number value is passed instead  of a date value.

       

      The details:

      I use sqldeveloper 4.1.3

      The parameter definition:

      the validation query:

       

      select count(*) from deelnemer_verd_per

      where dv_dat_ingang= {P_DATINGANG_OUD}

      and dv_dat_eind = {P_DATINGANG_NIEUW}

       

      results panes gives:

       

       

      Does anyone have any suggestions for another way to use the date parameter values in the validation query?

      Is this a bug?

       

      Kind regards

      Teun Theunissen