This discussion is archived
3 Replies Latest reply: Feb 10, 2013 8:42 PM by yash_08031983 RSS

error code :invalid query form heirarchical tree?

yash_08031983 Newbie
Currently Being Moderated
hello experts,
I am compiling form of 10 g in 11g .
form has tree item and used as menu form. in 11g on clicking the menu item , frm 47313error is generating.
form is running in 10g but in 11g at run time frm: 47313: invalid query for hierarchical tree is generating.

please help.

thanks
yash
  • 1. Re: error code :invalid query form heirarchical tree?
    CraigB Guru
    Currently Being Moderated
    Can you provide us with a sample of your code that is generating the error?

    Craig...
  • 2. Re: error code :invalid query form heirarchical tree?
    yash_08031983 Newbie
    Currently Being Moderated
    when-node-selected trigger code
    DECLARE
    htree         ITEM;     
    node                         FTREE.NODE;
    node_name           VARCHAR2(100);
    parent                    FTREE.NODE;
    parent_name          VARCHAR2(100);
    BEGIN
      htree := Find_Item('tree.tree4');
         node_name := Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.NODE_VALUE);
         :MENU_# := NODE_NAME;
         :GLOBAL.FORM_ID:=:MENU_#;---- VARIABLE ASSIGNED BY KESHAV ON DATE 20-AUG-2007; FOR FURTHER USE IN TASK GENERATOR
         SELECT initcap(MENU_PATH) INTO :MENU_PATH FROM SYS_MENU_M
                        WHERE MENU_# = node_NAME;
         parent := FTREE.GET_TREE_NODE_PARENT(htree,:SYSTEM.TRIGGER_NODE);
      parent_name := FTREE.GET_TREE_NODE_PROPERTY(htree,parent, FTREE.NODE_LABEL); 
      IF parent_name = initcap('Favorites') THEN
           SET_ITEM_PROPERTY('tool.add',TOOLTIP_TEXT,'Delete from Favorites');
      ELSE
           SET_ITEM_PROPERTY('tool.add',TOOLTIP_TEXT,'Add to Favorites');
      END IF;
    END;
    
    --
    when-node-activated code
    DECLARE
    htree         ITEM;     
    node                         FTREE.NODE;
    node_name           VARCHAR2(100);
    parent                    FTREE.NODE;
    parent_name          VARCHAR2(100);
    BEGIN
      htree := Find_Item('tree.tree4');
         node_name := Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.NODE_VALUE);
         :MENU_# := NODE_NAME;
         :GLOBAL.FORM_ID:=:MENU_#;---- VARIABLE ASSIGNED BY KESHAV ON DATE 20-AUG-2007; FOR FURTHER USE IN TASK GENERATOR
         SELECT initcap(MENU_PATH) INTO :MENU_PATH FROM SYS_MENU_M
                        WHERE MENU_# = node_NAME;
         parent := FTREE.GET_TREE_NODE_PARENT(htree,:SYSTEM.TRIGGER_NODE);
      parent_name := FTREE.GET_TREE_NODE_PROPERTY(htree,parent, FTREE.NODE_LABEL); 
      IF parent_name = initcap('Favorites') THEN
           SET_ITEM_PROPERTY('tool.add',TOOLTIP_TEXT,'Delete from Favorites');
      ELSE
           SET_ITEM_PROPERTY('tool.add',TOOLTIP_TEXT,'Add to Favorites');
      END IF;
    END;
    both code showing error in 11g at run time

    first code: 47307: can not get the tree node property
    second code: 47313


    i also pll library of 10g code showing error in 11g at compile time
    error: run_product must be declare.
    can't we uise run_product built-in in 11g????
    thanks
    yash

    Edited by: yash_08031983 on Feb 6, 2013 8:18 PM
  • 3. Re: error code :invalid query form heirarchical tree?
    yash_08031983 Newbie
    Currently Being Moderated
    thanks all,

    its now working. some attached library was creating the problem. due to which i was not working.
    i removed that lilrary. now code is working.

    removed library was webulit_less

    webutil_less lib
    ---function---
    FUNCTION GET_IP_ADDRESS return VARCHAR2 is
    begin
    return WebUtil_Core.getClientIPAddress;
    end GET_IP_ADDRESS;

    webutil_less lib end;

    i was using the function on when-node-activated trigger...

    :GLOBAL.client_machine_ip:=WEBUTIL_CLIENTINFO.GET_IP_ADDRESS;

    ---------
    i made it comment but its just temporary solution.

    will i have to configure the webutil pll on newly installed 11g.

    WebUtil_Core.getClientIPAddress is not working.
    please help to find the solution

    thanks
    yash

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points