on 05-02-2008 7:02 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.