Skip to Content

SAP PI :jdbc output parameter as response

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

Add comment
10|10000 characters needed 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

  • Get RSS Feed

1 Answer

  • Nov 08, 2016 at 02:55 AM

    Hi Narsaiah!

    Take a look at this thread:

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

    I guess it answers to your question.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded