cancel
Showing results for 
Search instead for 
Did you mean: 

PI 7.31 Sender JDBC Adapter Stored Procedure Multiples Outputs

Former Member
0 Kudos

Hi,

In a SAP PI  7.31, I have to configure a JDBC integration scenario  JDBC -> PI -> AbapProxy. The BD is SQL Server 2008. Can be set in the sender JDBC Adapter in the field SQL Query Statement calling a Stored Procedure and returns two or more tables, for example DocsHeader, DocsPosition, DocsAditionals.

If supported, as in the example of Stored Procedure call and receiving XML tables.

Regards,

Johnny Muñoz

Accepted Solutions (0)

Answers (1)

Answers (1)

iaki_vila
Active Contributor
0 Kudos

Hi Jhonny,

As far as i know there isn't any incompatibility to use a stored procedure in jdbc sender with SQL server.

By SAP documentation:

○ Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.

I think you could do a DB view which contains the three tables.

One example that deal about the XML obtained with the jdbc sender:

http://scn.sap.com/people/thorsten.nordholmsbirk/blog/2009/04/23/xml-result-from-jdbc-adapter-stored...

Regards,