Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
I am watching this to see how it works out for you. I am trying to import to create multiple requisitions to various vendor and in turn create Purchase Orders. (using Excel)
jim
From: ABAPxxxGoddess via sap-dev [mailto:sap-dev@Groups.ITtoolbox.com]
Sent: Thursday, September 30, 2010 2:09 AM
To: jkhayes
Subject: RE:[sap-dev] Bulk insert SQL command to transfer data from SAP to Oracle - CL_SQL_CONNECTION
Posted by ABAPxxxGoddess
on Sep 30 at 2:09 AM Mark as helpful
Hi Mark from Scottland!
Thanks for a very cool and reliable reply ^^,
I'm currently trying to do the databaselink as you suggested, trying to make it work. But I'm still waiting for our company's Oracle God to do that link. I'll be back here for the result.
Hi Horacio,
Nope,I'm still working on this, taking much of my time by our Oracle guys here. So, what's with this Native SQL? Don't I have to create a database link as what suggested by Mark above? Is this different from using the class CL_SQL_CONNECTION? Sorry coz I'm not much familiar with these SQL commands
Tell me what's on your mind so I could also make it a try while waiting for our Oracle guys here.
---------------Original Message---------------
From: ABAPxxxGoddess
Sent: Saturday, September 25, 2010 2:03 PM
Subject: Bulk insert SQL command to transfer data from SAP to Oracle - CL_SQL_CONNECTION
> Hi,
>
> I need to do performance tuning for an export program that transfer data from SAP to Oracle. It uses the class CL_SQL_CONNECTION to do this. In the insert data SQL command part, it does the insertion row by row which taking up so much time.
>
> My question is, is there a way to do bulk insert? I tried to make it into statement INSERT INTO oracle_table SELECT * FROM sap_internal_table, making it inserting the whole contents of the table one time, passing the table itself.
> But this gives an error message 'table not exist'. If I make the SAP internal table as a custom table, the problem would be saving of data into this custom table. Other data will be omitted because of the primary key concern.
>
> Please help me on how to do this. Thanks.
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  _.____.__ |
Mark as helpful
