Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC to Proxy scenario

Hi,

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.

regards

Debansu

Former Member
Not what you were looking for? View more on this topic or Ask a question