Hi, I'm trying to produce a stored procedure or function which would allow
me to fetch tree data stored in a table.

Records of this table looks like:
Id | ParentId | Value1 | Value2....

What I want to do is to fetch some rows starting from an Id number and using
this number as ParentId to get child rows recursively to produce single list
of rows. Is there is a way to join (union) cursors taken from subsequent
function calls to fetch their records somehow? I was also thinking about
using temporary table but if there's a simpler way, please let me know .

Thanks,
wish

Hi,

I think there is no need to use pl/sql to select such kind of data. Oracle
has the 'start with ... connect by' clause that can be used to select
hierarchical data. Here you have an example of usage in
http://www.adp-gmbh.ch/ora/sql/connect_by.html

So, you can use a simple query in SQL:

select
level,
id,
parentid,
value1,
value2
from
yourtable
start with
parentid is null /* root */
connect by prior
id = parentid;


--
KM