JOWENAB   0 pts.  |   May 24 2005  4:59AM GMT

Hi,
If DBlink was already set, You may use the native sql commands for updating.
*–to connect
* where gd_connect contains the logical name for the
* database connection set up by your BASIS team
* SAMPLE connection only “ITSCON”
GD_CONNECT = “ITSCON”.
EXEC SQL.
CONNECT TO :GD_CONNECT
ENDEXEC.
*—Populate your internal table having thesame structure
*—as with the remote DB
it_oradb- =
it_oradb- =
append it_oradb.
*–to insert
EXEC SQL.
*–then you can insert here the normal SAP SQL commands
INSERT from table :it_oradb
ENDEXEC.

Thanks,
Jowen

Arthur101   0 pts.  |   Jun 1 2005  2:51AM GMT

I don’t market this product but have you considered using TAVIZ
The product provides links from multiple foreign databases to Oracle including interfaces into Oracle Apps.

The advantage of Taviz is that you can clean up data and gather statistics on rows extracted, loaded etc.
The downside may be cost. It is some years since I used it on a project but its merit was that it worked. In complex loads Taviz was sometimes thought to be slow, but this was usually down to the Apps architecture rather than the basic load activity. Arthur Davies