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

[former_member191531]

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

[VijayKonam]

Send all of your data to one SP and in the SP write the logic. One thing is SP will not support repeating strucutures. You might have to send an XML stream to one data field of the SP and the SP should parse it to DataSet or RecordsSet.

VJ