Skip to Content
0

SAP PI :jdbc output parameter as response

Nov 07, 2016 at 08:43 PM

99

avatar image

Hi All,

Can any body help on how to get JDBC stored procedure output parameter values as response in sap pi(please provide mapping for response).

JDBC Stored procedure fields as like below:

Customer ID -in Put

Customer Name- in Put

Customer Add number -output

I need to hold Customer Add Number as response.

Thank you,

Narasaiah T

10 |10000 characters needed characters left characters exceeded

Hi,

Create receiver structure as below

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

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

</storedProcedureName >

</StatementName5>

in your case

customer id and customer name give IsInput as attribute and hardcode to true and for

Customer Add number give IsOutput as attribute hardcode to true

Regards

Pavan

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Evgeniy Kolmakov Nov 08, 2016 at 02:55 AM
0

Hi Narsaiah!

Take a look at this thread:

https://archive.sap.com/discussions/thread/1726262

I guess it answers to your question.

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded