DBCO: modify multiple row to external database Oracle

[former_member189009]

Dear friends,

        We have a requirement, we will use DBCO to create connection with external database Oracle, and we need to modify(when it exist, it will update when it doesn't it insert) a lot of rows into table in Oracle. so I need help about this two question:

1. Because we have a lot of data to insert into Oracle,so how do we insert our internal table into Oracle in our ABAP program?

2. Sometimes we have to insert data when it doesn't exit, or we need to update data when it exist, so how do we realize this function in oracle?

Thanks for your sincerely answer.

Zhang

[Sandra_Rossi]

I think you should better create a file with the data to update, create a procedure or script in Oracle to load data from the file, that you call from ABAP, and look for a solution in Oracle forums (search for instance "oracle mass update file").

[former_member189009]

Dear Sandra,

        Thanks for your sincerely answer. If we have to do this in ABAP , do you have any suggestion ?

[Sandra_Rossi]

Use ADBC - ABAP Database Connectivity

You should find some examples in the forum too, how to do INSERT.