0 Replies Latest reply on Nov 26, 2013 12:53 AM by New Rodeo

    11g H tree won't go past a depth/level of 2

    New Rodeo

      I've built a number of h-trees before, but for some reason this one won't extend past a depth/level of 2.

       

      I programatically add group rows and values.  It will only have the root and 3 levels, so they are hard coded in the nested cursor loops.

      [pre]

      for rec1 in csr1 loop

      set_group_number_cell(v_level, i, 2);

      for rec2 in csr2 loop

         set_group_number_cell(v_level, i, 3);

         for rec3 in csr3 loop

           set_group_number_cell(v_level, i, 4);

         end loop;

      end loop;

      end loop;

      [/pre]

       

      The data elements show properly from all cursors, but for csr2 and csr3 the depth is 2 for all records.

       

      Any ideas?

      Thank you.