FRM-47321 - Data Used to populate Tree is invalid.

[jctq]

Srs.

I would like a further help.
I'm making a very simple example here for popular a tree.

I wanted help from you to see what is wrong.

The code is this:

Select all

DECLARE 
   htree         ITEM; 
   top_node      FTREE.NODE; 
   new_node      FTREE.NODE; 
   item_value    VARCHAR2(30); 
   xtopico       tab_dicas.topico%type; 
   xassunto      tab_dicas.assunto%type; 
   num           number; 
   xrg           RECORDGROUP; 
   XQUERY        VARCHAR2(50);  
cursor T_topico is 
  select topico 
    from tab_dicas 
       group by topico; 
        
cursor T_assunto is 
  select assunto  
     from tab_dicas 
        where topico = xtopico 
           group by assunto ; 
         
          
                   
 
BEGIN 
   -- Find the tree itself. 
   htree := Find_Item('BL_TREE.T_DICA'); 
 
   -- Copy the item value to a local variable. 
   item_value := xtopico; 
 
   -- Add an expanded top level node to the tree 
   -- with no icon. 
   for i in T_topico loop 
        
           
       --ftree.pOPULATE_TREE (htree); 
       new_node := Ftree.Add_Tree_Node(htree, 
                                       Ftree.ROOT_NODE, 
                                       Ftree.PARENT_OFFSET, 
                                       Ftree.LAST_CHILD, 
                                       Ftree.EXPANDED_NODE, 
                                       I.TOPICO, 
                                       NULL, 
                                       i.topico); 
          
       xtopico := i.topico; 
       xrg := find_group ('rg_a'); 
       --XQUERY := 'select assunto from tab_dicas where topico = ''' ||  :?: xtopico ||  ''' AND ROWNUM =1'; 
       --top_node := find_tree_node (i.topico); 
       Ftree.Add_Tree_Data(htree, 
                           new_node, 
                           Ftree.parent_offset, 
                           Ftree.last_child, 
                           ftree.QUERY_TEXT, 
                           'SELECT 1 FROM DUAL');                                 
     
                         
   
   end loop; 
    
   --num:= show_alert ('alert_message');	 
end;

[stcoutinho]

Ola JCTQ,

I am responding to this open open topic, in the case of other forists to come across this problem:

This topic seems to give an overview About Trees:

http://andreas.weiden.orcl.over-blog.de ... 07730.html
The topics below revolve around the error that you reported:

http://www.orafaq.com/forum/t/99682/ https://community.oracle.com/thread/939776?tstart=0 http://oracle.ittoolbox.com/groups/tech ... rms-507914
Hugs,

Coutinho