JDBC Sender adapter - Oracle - Stored Procedure - Error

[Former Member]

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.

So please clarify the doubts and help me.

With regards,

Jilan

[JoelTrinidade]

Hi Jilan,

Unlike what was mentioned in the link given by you that oracle returns cursor and not resultset is not completely true. It may be difficult but certainly not impossible.

Refer : http://www.enterprisedt.com/publications/oracle/result_set.html

regards

joel