Skip to Content
Former Member
Oct 17, 2011 at 06:26 AM

Stored procedure design(IDoc to JDBC)


I need design inputs from you people,

My requirement as follows, we are creating orders(IDoc) in SAP and want to insert data in to Data base table, one IDoc data to be inserted in to multiple tables(min 4).I developed interfaces it is working fine, sometimes we expect 50k orders from SAP per day,i.e 50K IDocu2019s , it min 2lac insert operations performing on data base ,so planning to change my design.

How can I reduce number of insert statements to process 50k IDocu2019s per day.

Using stored procedure one option but stored procedure structure bit different. Like if I want to insert data 10 times in to data base table, then I written logic to repeat access tag multiples times.

But how can I do it stored procedure.

Any pointers?