Skip to Content

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

JDBC-Adapter: Several inserts in a stored procedure possible?

Hello,

I'm using the JDBC-Adapter for writing data to an oracle database.

At the moment, the data are mapped in the XI to several stored procedures(SP), one SP for each line. In this way, the data will be written to a temporary file. These data will be polled by Oracle then, to write them in the final table in one session.

Is there a way to avoid the temporary file? I mean, is it possible to give over an array from XI to Oracle in only one SP?

Thanks,

Juergen

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