Hi
We are sending vendor master data from SAP to SQL & ORACLE database .
It is working successfully for SQL.
we have deployed oracle drivers, completed the configuration part.
When idoc is triggered in SAP,data is uploaded in SQL successfully....but it is showing the following error for Oracle....
....." Unable to execute statement for table or stored procedure. 'tblVendorAddress' (Structure 'Table') due to java.sql.SQLException: FATAL ERROR: Column 'cVendorCode' does not exist in table 'tblVendorAddress' "......
cVendorCode in SQL is defined as cVendorCode ... but in Oracle it is defined as CVENDORCODE...
If i change the datatype in XI as CVENDORCODE...my SQL scenario will not work(cVendorCode)..
I don't want to change my XI datatype structure....records should be updated in SQL & Oracle datadase at the same time.
Please suggest a solution..
Regards
Abhijit