Saturday, October 10, 2015

Oracle tree to get the node value and label

declare
   htree item;
   node_label varchar2(200);
   node_value varchar2(200);
Begin
       htree := Find_Item('<tree_block>.<tree_name>');  -- provide your block name and tree name 
       node_value:= Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.NODE_VALUE);
       node_label:= Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.NODE_LABEL);
   -- Based on label or value you can write the actions here
End

No comments:

Post a Comment