How to copy the Data From Oracle Table To SAP Table

Hi Friends,

We need to copy the data from Oracle Database Table to SAP Table. The data should be updated simultaneously in both tables . Should I write a program that contains the native sql statement like EXEC SQL PERFORMING WRITE,....

I appreciate any suggestions regarding this.

Regards

CSM Reddy