JDBC call to a Stored Procedure in UDF

[Former Member]

Hello Experts,

I need your kind suggestions on how to perform a JDBC call to a Stored Procedure in UDF. Suggest me the required API and any other better suggestions to achieve the functionality.

My actual requirement is to call JDBC Stored procedure in mapping based on the response from RFC and the combined result needs to send back to sender.

[Shabarish_Nair]

if you are looking to implement this blog /people/arpil.gupta/blog/2008/11/03/workaround-for-jdbc-scenarios then i suggest reading through the comment sections to understand the drawback of such a design.

Instead do it as a separate call (a sync send via BPM for example)

[arkesh_sharma]

Hi Shabarish,

I have a similar scenario where I need to make a call to a SP in my JDBC Lookup UDF, get the result and use it in my mapping. Can I use the Lookup code to make a call to a SP? If Yes, what should I mention in my query string?

Thanks,

Arkesh

[Former Member]

Please refer to these -

/people/arpil.gupta/blog/2008/11/03/workaround-for-jdbc-scenarios

http://help.sap.com/javadocs/NW04S/current/pi/com/sap/aii/mapping/lookup/DataBaseAccessor.html