Using a stored procedure for a sender jdbc adapter

[Former Member]

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

[Former Member]

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

[Former Member]

Here we go... Enjoy..

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

Nilesh

[bhavesh_kantilal]

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

[former_member184543]

hi,

Refer this thread

Warm Regards

Sanjo

Award Points if helpful!!!

[Former Member]

Hey

The link you have given is of 2006,at that time it was not possible with oracle,but now it is posible with PI 7.0.

Thanx

Aamir

[former_member184543]

Thanks Amair for the correction

Warm Regards

Sanjo

[Former Member]

hey

here you go

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

Thanx

Aamir suhail