JDBC Sender Cursor

[Former Member]

Hi,

We have XI 7 SP9 and are looking at using and Oracle Cursor in a JDBC.

Is this possible? If not then what SP do we need to upgrade to so it is possible?

Thanks

Gareth

[Former Member · Accepted solution]

Hi,

this is possible to use Cursors with Oracle,

Please go through the below links

These links are of having verious scenarios as per the requirments, but the Cursors are sued in it thta you could refer.

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups Step No 5.

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Thanks

Swarup

[Former Member · Accepted solution]

Hi,

Also refer below details

http://help.sap.com/saphelp_nw04/helpdata/en/43/a9c38c09f417b7e10000000a1553f6/content.htm

thanks

Swarup

[Former Member · Accepted solution]

Most of those links look like they are using Cursors on JDBC Receivers. Its a sender we are wanting to use

[Former Member · Accepted solution]

Gareth,

If I'm not wrong: cursor is an internal temporary structure and can't be accessed directly by SQL call, right? So I don't think it is possible to make a call from JDBC adapter. You must provide as a parameter SQL statement. I don't believe, there is other option, than creating a new table or view.

Maybe, but just maybe, it would be possible to call a function, which would return values from the cursor. But I'm not sure with it.

Peter

[Former Member]

Peter,

i think your correct. i will take a look into the function side of things.

Thanks all

[Former Member]

Hi Gareth!

I don't think, this is available at all.. Why do you want to access a cursor? Why don't you create for eaxmple a view?

Can you provide us more details on your requirement?

Peter

[Former Member]

Peter,

This is an existing interface we have in a different system that we are looking to convert to XI. We are hoping to have as little impact as possible on the sending and receiving systems.

[prabhu_s2]

i think curzors are not supported here.