Using Oracle Stored Procedures & Sender JDBC Adapter

[HarshC]

Hi,

I'm investigating our options of using Oracle(9i) SP's with the XI JDBC Sender Adapter(7.0).

Can you please help with the following:

a. Can we now use Oracle SP's that return cursors with JDBC Sender Adapter(XI 7.0 Latest SP)?

b. If not, is it possible to configure an Oracle SP to return a resultset instead of a cursor?

c. The following blog is an alternate to Oracle SP's. /people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

What are the limitations(if any) of this approach.

d. If anyone has already done this, can you please list an example of: i. how do we configure the Sender JDBC Channel(Execute Command)

ii. how do we design the DT/MT's to handle the cursor.

Thanks,

Harsh

[prateek]

a. Invoking Oracle stored procedures from within a JDBC sender channel is only possible for Oracle DBMS versions >= 10.2.x using so-called table functions

b. I think no for ur version

c. The only limitation is the Oracle Version 10.2.x

Regards,

Prateek