We need to insert SAP data directly into a staging table in a non-SAP app on a remote Oracle 9.2 DB. We've been given write access to only this one table in the remote Oracle DB.
Currently, we create a flat file in SAP (on a DB400 DB), FTP the file to an intermediate Oracle DB owned by our group, SQL*Loader it into our Oracle DB, then use Oracle's database link technology to insert into the table in the target remote Oracle DB.
Can we write to this table directly from SAP? How do we do it (Function module, BAPI, native SQL, or what)? Thanks!