How to pass multiple rows to a Stored Procedure(JDBC Receiver)

[Former Member]

Hi,

Scenario : File -->XI --> JDBC.

I need to make one call to SP to pass multiple rows(ex: 100 rows).Oracle DB.

1. How should my stored procedure look like ?

2. How should my data type should look like?

Thankx.

Moni

[Former Member]

Hey

have a look at the following thread

Thanx

Aamir suhail