App Connect

App Connect

Join this online user 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.

 View Only
Expand all | Collapse all

Help Needed: Calling Oracle Procedure in ESQL with Multiple Rows

  • 1.  Help Needed: Calling Oracle Procedure in ESQL with Multiple Rows

    Posted Thu April 24, 2025 02:59 PM

    Hello everyone,

    I'm looking for guidance on how to call an Oracle database procedure from ESQL that takes two input parameters and returns multiple rows. I've defined the procedure to use a SYS_REFCURSOR to handle multiple row outputs, but I'm unsure how to properly set this up in ESQL and retrieve the results.

    If you have experience with this or could point me to relevant resources or examples, I'd greatly appreciate your help!

    Thank you!



  • 2.  RE: Help Needed: Calling Oracle Procedure in ESQL with Multiple Rows

    Posted 25 days ago

    Hi Vikas,

    You can use dynamic result set .Here 2 means 2 rows to be retrieved

    CREATE PROCEDURE myProc1 (IN P1 INT, OUT P2 INT)
      LANGUAGE DATABASE
      DYNAMIC RESULT SETS 2
      EXTERNAL NAME "myschema.myproc";
    


    ------------------------------
    Arif Jamil Ansari
    ------------------------------