Skip to Content
author's profile photo Former Member
0
Former Member

JDBC Sender Cursor

Posted on Jan 22, 2008 at 11:48 AM 19 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 11:59 AM
    3

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jan 22, 2008 at 12:15 PM

      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

    Comment on This Answer
  • author's profile photo Prabhu S
    Prabhu S
    Posted on Jan 22, 2008 at 11:53 AM
    1

    i think curzors are not supported here.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 11:58 AM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jan 22, 2008 at 12:02 PM

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 12:19 PM
    0

    Peter,

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

    Thanks all

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.