Skip to Content
Former Member
Jun 14, 2010 at 01:05 PM

JDBC Date Problem



I am calling a SP in Oracle. I have to pass a date but get error.

my date field is like below:

<I_DATE hasQuot="NO" type="DATE">TO_DATE('10/05/31','YY/MM/DD')</I_DATE>

I executed it directly in the DB like above and it worked. But in JDBC it doesnt. The error is below. Any ideas? Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_delivery' (structure HEADER): java.lang.IllegalArgumentException