1 Reply Latest reply on Jul 7, 2014 3:24 PM by Frank Kulash

    How to get releated records from diff procedure


      I have three different procedures which returning result set (by using ref cursor) based on based on give id;


      for all the procedure input id is same.


      After execution the procedures I am having three different result.


      --proc 1o/p

      1  r1    r2   r3   r4   r5   r5


      --proc 2 o/p

      1  t1    t2   t3   t4   t5   t6


      --proc 3 o/p

      1  g1   g2   g3   g4  g5  g6



      I want data like below (id : 1)



      1.  r1,  r4, t2  ,t4,  g5,  g6


      kindly help me on this!!!


      Thanks in advance.

        • 1. Re: How to get releated records from diff procedure
          Frank Kulash



          Whenever you have a problem, please post a complete test scipt that the people who want to help you can run to re-create the problem and test their ideas.  In this case, include your procedures (or simplified versions of them), and CREATE TABLE and INSERT statements for any tables they need.

          Always say which version of Oracle you're using (for example,

          See the forum FAQ: https://forums.oracle.com/message/9362002#9362002


          Why do you want that output?  Why not, for example


          r1, r2, t1, t1, g1, r1

          Post a couple of different inputs, and the results you want from each.  Explain how you get those results in each case.