I am doing a IDOC to JDBC scenario .. I will be getting a material master IDOC and i need to insert that data in multiple database tables .. i am considering to use stored procedure for doing this .. but the question i have is .. in my case each segment in IDOC is like a Array of type structure ..so how do i pass this structure array to store procedure . so that it can loop through the array and insert in appropriate tables.
You cannot pass an array of parameters as argument to Stored Procedure. But you can put logic into the stored procedure to insert into mulitple tables and make the statement tag in XI 0..unbounded. So you would be making a call to the stored procedure for each child structure in the IDOC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.