In my current package, I have 3 procedures which return ref cursor result set. The number of columns is same across all procedures.
PROCEDURE A(p1 VARCHAR, v_ref1 OUT SYS_REFCURSOR )
PROCEDURE B(p2 VARCHAR, v_ref2 OUT SYS_REFCURSOR )
PROCEDURE C(p3 VARCHAR, v_ref3 OUT SYS_REFCURSOR )
Now, I have requirement where in I need to combine the output of all the 3 procedures depending upon the parameter passed.
You can consider that I p1, p2 and p3 are being fetched from some table and I need to call the procedure A, procedure B and procedure C respectively
and the output should be a ref_cursor which is nothing but v_ref1+v_ref2+v_ref3
I need to pass this consolidated ref cursor output to Java application