topic Re: DBCO: modify multiple row to external database Oracle in Application Development and Automation Discussions

DBCO: modify multiple row to external database Oracle

former_member189009 — Fri, 30 Sep 2016 07:27:44 GMT

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

Re: DBCO: modify multiple row to external database Oracle

Sandra_Rossi — Fri, 30 Sep 2016 17:56:04 GMT

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").

Re: DBCO: modify multiple row to external database Oracle

former_member189009 — Tue, 04 Oct 2016 03:34:37 GMT

Dear Sandra,

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

Re: DBCO: modify multiple row to external database Oracle

Sandra_Rossi — Tue, 04 Oct 2016 06:57:22 GMT

Use ADBC - ABAP Database Connectivity

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