Hi All,
I have used the below code for populating a tree item, but when i run the below code it throws the
error FRM-93652 The runtime proess has terminated abnormally.
DECLARE
rgTree RECORDGROUP;
vcQuery VARCHAR2(2000);
nStatus NUMBER;
itTree ITEM := FIND_ITEM ('BLOCK_TREE.TREE_EMPLOYEE');
BEGIN
rgTree := FIND_GROUP ('RG_TREE');
IF Id_Null(rgTree) THEN
rgTree := Create_Group('RG_TREE');
END IF;
-- Clear Tree
Ftree.DELETE_TREE_NODE (itTree, Ftree.ROOT_NODE);
-- Build up a new Query, if desired
vcQuery := 'SELECT -1 as NODE_STATE,LEVEL as NODE_DEPTH,ENAME as NODE_LABEL,
DECODE(LEVEL,1,''insrec'',''nxtblk'') as NODE_ICON,
To_Char(EMPNO) as NODE_VALUE
FROM EMP CONNECT BY PRIOR EMPNO=MGR
START WITH MGR IS NULL
ORDER SIBLINGS BY ENAME';
-- Repopulate Record-Group
nStatus := POPULATE_GROUP_WITH_QUERY (rgTree, vcQuery);
-- Repopulate Tree
Ftree.POPULATE_TREE(itTree);
END;
What and where is the problem with this code.
How to solve this issue ?