7 Replies Latest reply on Aug 30, 2019 10:06 AM by Ria_B

    Why does a dateconversion works when run in sqldeveloper but not via ords?



      I have created a restmodule with the following sql in ORDS :


      Select ......

      AND pos_dt between to_date(:in_date) || ' 00:00:00,000000000'

      and to_timestamp(to_date(:in_date) || ' ' || :in_time,'YYYY-MM-DD hh24:MI:ss')



      pos_date id timestamp(6) and the inparameters are ?in_date=2019-05-09&in_time=10:00:00


      when running the sql in sqldeveloper it runs fine and returns data but running it via ords url

      I get

      • An unexpected error with the following message occurred: Header:Error-Reason Cannot contain CRLF Charcters


      and in the weblogic serverlog I can see:  Error Msg = ORA-01861: literal does not match format string


      Does anyone know why the behaviour is different?


      Thanks & Best Regards