Hi Tom, I have a situation in which I have to use nested tables. The problem is they are nesting too deep, i.e, we have nested to the fifth level. We dont have any problem as such using the tables individually but while retrieving the data using the tables in which they are nested, we are finding it very difficult. Nesting the tables was our solution for encapsulating the data. Is there any other better way to do this? I will appreciate your response... thanks, vasu
Can you describe what you mean by 5 levels deep with regards to a nested table type? Until Oracle9i, collections only go one level -- I need to know whether you are talking about a multi-level collection in 9i or if you have some specific construct you are using in Oracle8i. An example of what you've done would be useful.
Thomas Kyte (email@example.com) <A HREF="http://asktom.oracle.com/" TARGET=_blank rel="nofollow">http://asktom.oracle.com/</A> <BR>Expert one on one Oracle, programming techniques and solutions for Oracle.<BR>http://www.amazon.com/exec/obidos/ASIN/1861004826/ <BR>Opinions are mine and do not necessarily reflect those of Oracle Corp