Executing Stored Procedures from JDBC adapter

Hello,

I came across a particular integration situation, XI needs to call a oracle stored procedure(still DB guys need to build), and needs to send multiple lines of data to insert into a table.

I have couple of questions:

1. Can we create a stored procedure with input as "table type" which can take multiple lines of records.

2. if above is possible then can we call this procedure from XI if so what is the syntax for the jdbc adapter?

Please let me know if any body has clues on this, you feedback is really appreciated.

Please let me know if you need any further info?

Thanks in advance..

-laxman