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

How to get list of rows from oracle stored procedure to IBm BAW using Call stored procedure service

  • 1.  How to get list of rows from oracle stored procedure to IBm BAW using Call stored procedure service

    Posted Thu January 23, 2025 08:50 AM

    I have a oracle stored procedure where OUT parameter is declared has SYS_REFCURSOR, now in IBM BAW we are trying to call procedure using CALL Stored_Procedure_name(?) and

    what SQL parameter type we need to set in iBM BAW to match the oracle stored procedure OUT type?



    ------------------------------
    sashidhar allampalli
    ------------------------------


  • 2.  RE: How to get list of rows from oracle stored procedure to IBm BAW using Call stored procedure service

    Posted Thu January 23, 2025 11:11 AM

    it will be :
    "ORACLE_CURSOR"
    to find all possible type for it,

    go for the SQLParameter Type in the System Data ToolKit and click on the type 
    then you can find in the Documentation panel all possible types



    ------------------------------
    Ziyad Hamed
    Automation Engineer
    Valleysoft | Center of Excellence
    New Cairo
    +201030314243
    ------------------------------

    Original Message