1 2 Previous Next 16 Replies Latest reply: Nov 19, 2012 12:57 PM by user12200443 Go to original post RSS
      • 15. Re: why? : ORA-06532: Subscript outside of limit
        user12200443
        awesome, I will give this a spin now. I appreciate the feedback.
        • 16. Re: why? : ORA-06532: Subscript outside of limit
          user12200443
          OK, amazing response, it worked like a charm and is exactly what I was looking for:

          BEGIN
          OPEN get_all_locations;
          FETCH get_all_locations BULK COLLECT INTO v_all_locations;
          CLOSE get_all_locations;
          END;


          ---
          I need to iterate over this collection at various points (in multiple procedures) in order to move some data around. This collection represents the root nodes (by specifying the type to the cursor) and now I need to get all the children but this will be the topic of an additional post.

          I have a representation in the DB like a folder structure and need to create another collection that consists of all children depth first and not sure how to do this. I appreciate this response, I learned a lot.
          1 2 Previous Next