cancel
Showing results for 
Search instead for 
Did you mean: 

TO_DATE and Oracle JDVC Receiver

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

TO_DATE must covert my string into oracle date. It doesn't matter with date format is set. I have tryid to insert the row directly - It works. But I don't know which SQL generates JDBC Adapter

Former Member
0 Kudos

There is a blog on this. Check this out.

/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

regards

Shravan

Former Member
0 Kudos

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