How to use a atore procedure in the sender Jdbc adapter

[Former Member]

Hi Experts!

I am having a requirement to read multiple data from multiple tables from Oracle database at a time.

In sender side i am using JDBC Adapter. Here i want to know how can we use a store procedure to do this and can any one pls give a blog which guide me in design.

Thanks in advance,

Preethi.

[Former Member]

cretae ur JDBC sender Structure something like this:

<Mt>

<Row>

<A>

<B>

</Row>

<MT>

A ,B etc... will be ur field names in the stored procedures...

and in sender channel use: exec SP name

Note: there are few blogs also available for the same...

[former_member854360]

Pleasae see this thread

In space of select statement put

EXEC nameofstoredprocedure

and update statement

Put <TEST>

[Former Member]

Hi !

Thanks for your reply. can u pls give me sample store procedure which will read datas from multiple tables and i just confused how to design the source message type to multiple data from multiple table.

Regard's

preethi.