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?

    Ria_B

      Hi

      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

      Ria