BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
Back to discussions
Expand all | Collapse all

String output Stored procedure call from the IBM BAW platform

  • 1.  String output Stored procedure call from the IBM BAW platform

    Posted Tue September 10, 2024 01:43 AM

    Dear Team,

    I need to call a stored procedure that outputs a string (not a table) from the database. Could you please assist me with doing this using IBM BAW services flow

    Thanks

    Dilini



    ------------------------------
    dilini kulasuriya
    ------------------------------


  • 2.  RE: String output Stored procedure call from the IBM BAW platform

    Posted Wed September 11, 2024 04:14 AM

    Try using the "SQL Call Stored Procedure (SQLResult)" service flow and use debug to examine the "results" output variable and find the returned string



    ------------------------------
    ZAFIRIS KERAMIDAS
    ------------------------------

    Original Message


  • 3.  RE: String output Stored procedure call from the IBM BAW platform

    Posted Mon September 16, 2024 10:07 AM

    Thank you ! SQL Call Stored Procedure (SQLResult) did work . Here is a

    screenshot of how i assigned values to the required variables .



    ------------------------------
    Ishan Bandara
    ------------------------------

    Original Message