Skip to Content
avatar image
Former Member

Using a stored procedure for a sender jdbc adapter

Hi all,

The requirement is to use a stored procedure, for extracting data from a oracle database.

Is it possible to do this.

If yes, what should be the source structure in this case.

Please help with the exact soln.

Thanks!!

Younus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 20, 2007 at 05:23 AM

    hey

    here you go

    /people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

    Thanx

    Aamir suhail

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 20, 2007 at 05:25 AM

    hi,

    Refer this thread

    Stored Procedure in sender JDBC

    Warm Regards

    Sanjo

    Award Points if helpful!!!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 06:56 PM

    Hi all,

    Can anyone provide me with a good blog or link where in i can find the soln to this problem?

    If it is possible in PI 7.0, just give me some example as to how we can achieve this.

    Thanks

    Younus

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Did you check the blog pointed by Aamir?

      /people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

      You will need to use Oracle Functions instead of Oracle Stored Procedures. Read thru the blog and the note pointed in the blog . Think it is quite a good example.

      Regards

      Bhavesh