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
------------------------------
Original Message:
Sent: Thu April 24, 2025 01:27 AM
From: vikas waghere
Subject: Help Needed: Calling Oracle Procedure in ESQL with Multiple Rows
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!