Query on creating Hierarchical Tree in Oracle Form
Posted on 2003-03-07
I am trying to create a H-Tree using Record Group in Oracle Form 6.But I am getting FRM-41072 (Cannot Create Group) and FRM-41076 (error populating group). I also saw the reasons for the form failures, but everything is fine according to me.Here is my Code:
PROCEDURE ADDHTREENEW IS
htree_id := FIND_ITEM('TREEDATABLK.HTREE');
IF NOT ID_NULL (htree_id) THEN
MESSAGE('ERROR CREATING ID OF TREE');
rg_id := FIND_GROUP('TREEGROUP');
rg_id := CREATE_GROUP_FROM_QUERY(rg_name,'SELECT 1,LEVEL,lname,NULL,to_char(SSN) from employee connect by prior ssn = superssn start with ssn = 987654321',FORM_SCOPE,20);
poprg := POPULATE_GROUP(rg_id);
htree := FTREE.ADD_TREE_NODE('TREEDATABLK.HTREE',htree,FTREE.PARENT_OFFSET,FTREE.LAST_CHILD,FTREE.COLLAPSED_NODE,'ORACLE','','ora');
In a WNF Trigger I am calling this procedure ADDHTREENEW.
Also one strange thing that I noticed- The Query passed to CREATE_GROUP_FROM_QUERY
(SELECT 1,LEVEL,lname,NULL,to_char(SSN) from employee connect by prior ssn = superssn start with ssn = 987654321) works absolutely fine in SQL PLUS.So, why it is not creating the group????
Also. I am adding one node at the last named ORACLE just to verify that tree is being actually created.
The node 'ORACLE' does appear.
I am using Forms [32 Bit] Version 184.108.40.206.3 (Production).
Thanks in advance.