Response from one stored proc. to another stored procedure call in JDBC

[Former Member]

Hi,

I have to call 2 stored procedures, where the response from first stored procedure ( an id) is mapped as a parameter to the second stored procedure call.

My question is that can this be achieved without using BPM?

Can we somehow map the response from the stored procedure 1 to stored procedure 2 parameter w/o using BPM?

I have to insert multiple rows using the stored procedure.

Should I use STATEMENT unbounded times ( which means stored procedure is called multiple times) or should I use the parameter as unbounded ( like an array, maybe define the parameter as an array in the stored procedure)?

From the performance standpoint, which approach is better?

Please suggest.

[Former Member]

Hi Ardent !

I think you could use 2 mapping programs (message mapping objects) in your interface mapping. The first one, executes and returns the ID to a message type defined by you for internal use only between both stored procedure executions. The second ones uses that message type as source message and the XML required by the JDBC for the second stored procedure execution as target message type. This can be done without BPM.

Regards,

Matias.