1 Reply Latest reply: Jul 7, 2014 10:24 AM by Frank Kulash RSS

    How to get releated records from diff procedure

    1152968

      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

          Hi,

           

          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, 11.2.0.2.0).

          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.