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.


#Applicationintegration
#App Connect
#AppConnect
#Integration
#Automation
 View Only
Back to discussions
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 04/24/25 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 05/19/25 10:25 AM

    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
    ------------------------------



Related Content