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

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.