Skip to Content

Using Oracle Stored Procedures & Sender JDBC Adapter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 02, 2008 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded