How to get the output value of Stored Procedure?

[Former Member]

with JDBC receiver adapter,Right?

I know to define a data structure

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

<table>realStoredProcedureeName</table>

<param1 [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

..

Thanks.

[Former Member]

Hi,

Thanks,

Madhu

[Former Member]

Hi,

For more clarification:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e02fc613-2b39-2a10-9e90-899cb257...

Thanks.

Boopathi

[Former Member]

hi shen,

JDBC adapter will act on Resultset

Check out the documentation at:

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

The documentation clearly says that "All return values are returned in an XML structure."

From my experience with the JDBC adapter, the response message has the same name as the query message, concatenated with _response.

For example if your outbound message type is MtMyMessage,

the returned message is MtMyMessage_response.

regards

kummari