Sync JDBC receiver to call a Stored procedure in SAP XI 3.0?

[Former Member]

Hi.

Is it possible to call a stored procedure in a sync JDBC receiver? If so how will the output look like...

The stored procedure inputs about 5 fields and outputs multiple line items.

... I did not find a blog for this particular scenario...So I would appreciate a detailed response...

We are on Xi 3.0 SP20...

Regards

Arvind...

[former_member181985]

[http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]

Use statement 5 template.

Edited by: Praveen Gujjeti on Mar 8, 2010 5:13 PM

[Former Member]

Hi,

The link does not show the outputXMl structure...

[former_member206760]

Example for stored procedure

sorry the steps were for the sender stored procedure...follow the steps by praveen

Edited by: Tarang Shah on Mar 8, 2010 5:42 PM

[former_member181985]

example:

<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT xmlns:ns0="http://somenamespace">
   <STATEMENT>
      <storedProcedureName action="EXECUTE">
         <table>STOREDPROCEDURENAME</table>
         <BusinessTranType type="CHAR">ZGQT</BusinessTranType>
       </storedProcedureName>
   </STATEMENT>
</ns0:MT>

[Former Member]

Isn't the e.g. you sent for the message going to the DB.... What is the structure of the output of the call... The link you sent me said it will in a table...but I am not sure of the exact structure...

[former_member181985]

once it goes to Adapter Engine the JDBC adapter converts this to native SQL command.

something like this: exec STOREDPROCEDURENAME @BusinessTranType='ZGQT2'

[Former Member]

Praveen,

I was referring to the XML structure of the stored procedure response (for the sync interface). the documentation in SAP does to show the XML structure of the response. it only states that the response will be in the form of a table.

regards,

Arvind R

[Former Member]

Arvind,

Please check this blog for the same:

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

Regards,

---Satish