how do i use stored procedure in jdbc to file interface.

[former_member191435]

Hi folks,

I read in help.sap.com about jdbc adapter. But what is stroed procedure how would I use in sender side and receiver side.

I mean how would I create in message type at the same time what are the configuration i need to do in jdbc communication channel

Thanks,

Enivass

[rajasekhar_reddy14]

implementing stored procedure scenario in sender side required work around, there is no standard mechanism i beleive.

[Former Member]

Hi,

After having search on help.sap.com, you should also search on SDN... :-)... because it's a classic topic !

A Stored procedure is like a litle program (*) created on the database (itself), inside which you can do what you want, like doing several SQL.

(*) in fact, a stored procedure is a procedure (program) stored in a database, so it's like a function module with input / output parameters.

For me, it's better to use a stored procedure, because by this way for PI (in a mapping) it's just to call a program (stored procedure) by passing some parameters (inbound fields), and that's all. After that, if the databae changes (evolution), then you can update directly your SQL inside the stored procedure without to change PI mapping. So it's more flexible than to call a SQL request INSERT / UPDATE / DELETE SQL directly in PI mapping, in that case, for every change in database, you have also to change your PI mapping.

Regards

Mickael

[former_member191435]

Mickael,

Thanks for ur reply...

For stored procedure how would i create sender and receiver data types

Thanks,

ENivass

[Former Member]

Hi enivas,

just respect the structure explained in Help SAP [Defining XML Documents for Message Protocol XML SQL Format|http://help.sap.com/saphelp_nwpi71/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm].

Then have a look on blog, wiki and pdf: like this one:

[step by step guide proxy to JDBC|http://www.google.fr/url?sa=t&rct=j&q=sdn%20jdbc&source=web&cd=1&sqi=2&ved=0CCMQFjAA&url=http%3A%2F%2Fwww.sdn.sap.com%2Firj%2Fscn%2Findex%3Frid%3D%2Flibrary%2Fuuid%2Fe0ac1a33-debf-2c10-45bf-fb19f6e15649%26overridelayout%3Dtrue&ei=ETjRTrpckJv6Bvrr3cUO&usg=AFQjCNFbnEQKi2KjFloHhVe1QnoMky6tTQ]

[]

[]

[|]

[|http://wiki.sdn.sap.com/wiki/display/XI/Advantages-DisadvantagesofStoredProcedureinJDBCScenario]

etc...

I let you to see by yourself the 30 blogs, 11 wiki and other pdf doc...

regards

Mickael

[former_member191435]

Thankx Mickael