Skip to Content
author's profile photo
Former Member

TO_DATE and Oracle JDVC Receiver

I have done exactly the same what was described in blog /people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

My XML SQL part is

<access>

...

<M_BIRTDAY hasQuot="NO">TO_DATE('12.12.2003','DD.MM.YYYY')</M_BIRTDAY>

</access>

But I am always gettion an error java.sql.SQLException: ORA-00907: missing right parenthesis

How to solve this problem? How to trace SQL of Adapter?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Sep 30, 2005 at 06:26 AM

    I think Oracle internal data format is something like this 23-Jan-2005. Better check it and one other thing in the the date conversion you can mention <b>mmm</b> which will give you the month name. I've tried it once the month was converted into 3 char month name. It works.

    regards

    Shravan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      JDBC Adpter is changing TO_DATE('value', 'value') to TO_DATE(''value'', ''value'').

      I changed Escape Symbol for Apostrophe from '' on '

      It is working now.

      I think Adapter is adding ' always