JDBC to Proxy scenario
Hope you are doing well.
I have a scenario where I need to fetch the data from an Oracle table and pass them on to SAP via proxy. Since, the data to be extracted from the Oracle db is huge, I want to call a stored procedure to fetch the data, and then pass them on in batches of say 100 records at a time to XI. To do this,I believe the stored procedure has to trigger the interface in XI.
I have seen a few blogs stating that a sender JDBC adapter cannot interact with a stored procedure since the latter provides the data in a cursor whereas XI needs the data in record sets.
Then how can I achive my objective? Please provide me some ideas.