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

JDBC Date Problem

26 Views

Hi,

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?

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_delivery' (structure HEADER): java.lang.IllegalArgumentException