Skip to Content
0
Jun 08, 2009 at 08:36 AM

Data insert in SQL & ORACLE databases

37 Views

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