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