Error when executing statement for table/stored proc. (structure 'Statement'): java.lang.IllegalArgumentException

[rohini_potham3]

Hi Experts,

My scenario is IDOC to JDBC (via stored procedure)

I am getting the above error.

Details of strcuture are below:

SP signature should be

  procedure SET_NOMINTATION(

    HEADER_NOMTK              in VARCHAR2,

    HEADER_ERZEIT             in VARCHAR2,

    HEADER_ERDAT              in VARCHAR2,

    HEADER_AEZEIT             in VARCHAR2,

    HEADER_AEDAT              in VARCHAR2,

    HEADER_TIMESTAMP          in DATE,

    HEADER_DONE               in VARCHAR2,

    HEADER_DELIND             in VARCHAR2,

    NOMINATION_ITEMS          in CLOB,

    ERROR_CODE                out int

  );

I have created a structure as

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:Nominationtable xmlns:ns0="XXXXXXX">

- <Statement>

- <SPName action="EXECUTE">

<table>itrans.tsw_staging_tables.SET_NOMINTATION</table>

<HEADER_NOMTK isInput="true" type="VARCHAR">00000000000000005810</HEADER_NOMTK>

<HEADER_ERZEIT isInput="true" type="VARCHAR">00000000000000005810</HEADER_ERZEIT>

<HEADER_ERDAT isInput="true" type="VARCHAR">084413</HEADER_ERDAT>

<HEADER_AEZEIT isInput="true" type="VARCHAR">07102010</HEADER_AEZEIT>

<HEADER_AEDAT isInput="true" type="VARCHAR">084500</HEADER_AEDAT>

<HEADER_TIMESTAMP isInput="true" type="DATE">09102010</HEADER_TIMESTAMP>

<HEADER_DONE isInput="true" type="VARCHAR">sysdate</HEADER_DONE>

<HEADER_DELIND isInput="true" type="VARCHAR" />

<NOMINATION_ITEMS isInput="true" type="CLOB">;;;;567;;;;;;;;</NOMINATION_ITEMS>

<ERROR_CODE isOutput="true" type="INTEGER">error_code</ERROR_CODE>

</SPName>

</Statement>

</ns0:Nominationtable>

Can anybody let me know where i am going wrong

[iaki_vila · Accepted solution]

Hi Rohini,

Try to change the date format of HEADER_TIMESTAMP tag:

Instead of:

<HEADER_TIMESTAMP isInput="true" type="DATE">09102010</HEADER_TIMESTAMP>

Try with:

<HEADER_TIMESTAMP isInput="true" type="DATE">09.10.2010</HEADER_TIMESTAMP>

or

<HEADER_TIMESTAMP isInput="true" type="DATE">2010-10-09 00:00:00.0</HEADER_TIMESTAMP>

Check how the target database has inserted the dates.

Regards.

[rohini_potham3]

hi Inaki,

Still i am facing the same issue with same error message.

Regards,

Rohini