Skip to Content
0
May 28, 2009 at 09:53 AM

Problem in the receiver JDBC channel

26 Views

hi,

I am facing some problem with the receiver JDBC channel which is trying to insert some data in ORACLE DB. My sample input XML file is,

<root>

<statement>

<table>EBILL_CUST_STATE_AGE_HDR2</table>

<CUST_CODE>BA001</CUST_CODE>

<CUST_ADDR>Rental Customer Name 1+Name 2street01+TEL: 0331694100

FAX:0331694103</CUST_ADDR>

<CRD_LMT>1000000.00</CRD_LMT>

<BG_AMT>1000000.00</BG_AMT>

</statement>

</root>

Error stack is,

Exception caught when executing statement for table/stored proc. 'EBILL_CUST_STATE_AGE_HDR2' (structure 'Statement_CUST_STATE_AGE_HDR2'):

java.sql.SQLException: ORA-00917: missing comma

Please help me in solving the issue ASAP.

Thanks,

Soorya