JDBC Sender adapter - Oracle - Stored Procedure - Error

Hello,

Need few clarifications on JDBC sender adapter and stored procedures when connecting to Oracle DB.

My scenario is, Oracle to SAPBW. So in sender JDBC adapter, we have used a SP having multiple SQL statements it, esp. one of the SELECT statment having Joins on a table and View.

My questions are,

1) Is it possible to have more SQL statements in SP for Sender JDBC?

2) Is the SP of Oracle DB returns resultset or cursor?

I have tried in searching the forum perticularly for connecting to Oracle as Sender and below like said that there is a limitation of XI JDBC when connecting to Oracle.

executing-an-oracle-stored-procedure-from-sender-j

So please clarify the doubts and help me.

With regards,

Jilan