Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Consolidate records for multiple ref cursors

Avatar of ajexpert
ajexpertFlag for United States of America asked on
Oracle Database
12 Comments1 Solution4097 ViewsLast Modified:
Hi Experts,

In my current package, I have 3 procedures which return ref cursor result set.  The number of columns is same across all procedures.

Example

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
ASKER CERTIFIED SOLUTION
Avatar of ajexpert
ajexpertFlag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 12 Comments.
See Answers