i am having a tree with nodes as A-Z. i need to add data to these nodes from another table such that node A is having data as.. names of all the employees starting with alphabet 'A'..etc
i am using a procedure to retreive the data.
PROCEDURE proc_add_tree_data(str char) IS
CURSOR cur_tree_query IS
select distinct emp_first_name
where emp_first_name like str||'%';
htree := Find_Item('BLOCK_TREE.HTREE');
fetch cur_tree_query into ename;
exit when cur_tree_query%notfound;
but this cursor is giving me error...invalid query for hierarchical tree.