Synchronous JDBC adapter(receiver side) with stored procedure

[ayan_chaudhuri]

Hi experts,

Can some database processing logic be included in receiver JDBC (synchronous) adapter...to put it simply

I have synchronous JDBC adapter in the receiver side..Using this JDBC adapter I want to get some response back from the table..

The requirement is not a simple fetch from the table..It involves some processing in the database side which I guess will be done by stored procedure..After this database processing , this output will be picked up by the JDBC adapter and will send to PI.

How can this be achived ..Any Blog..

Thanks

Ayan

[Former Member · Accepted solution]

Yes u can use stroed procedure and send back the response,

refer this link for stored procedure structure.

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

chirag.

[Former Member]

Hi,

Ck this:

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Thanks

Amit