Skip to Content
0
Former Member
Sep 30, 2005 at 06:23 AM

TO_DATE and Oracle JDVC Receiver

96 Views

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?