IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

How to pass values to Struct input type a JDBC adapter service.

  • 1.  How to pass values to Struct input type a JDBC adapter service.

    Posted Wed March 23, 2011 04:44 PM

    Hi,

    I need to pass input to an oracle pl/sql stored procedure whose input parameter is of type STRUCT.

    The data that I have in hand is in the below format.


    1234-T
    <REQ_DATE>30-MAR-2011</REQ_DATE>
    <REQ_QTY>5</REQ_QTY>


    1235-T
    <REQ_DATE>10-APR-2011</REQ_DATE>
    <REQ_QTY>4</REQ_QTY>

    The stored procedure is expecting the data in the below format:
    1234-T|30-MAR-2011|5
    1235-T|10-APR-2011|4
    —upto n items details

    I can concatenate all the tags in the input xml for each item into a single string and form a string list.

    I created JDBC adapter services with stored procedure template and stored procedure with signature template. The input param to the adap service is an object (as the stored proc is expecting a struct type).

    Now how do I pass the concatenated input to the adapter service?

    WM 7.1
    JDBC adap: 6.5
    Please help. Let me know if I need to share any other info. A little urgent.

    Best regards,
    KRV


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


Related Content