3 Replies Latest reply: Feb 10, 2013 10:42 PM by yash_08031983 RSS

    error code :invalid query form heirarchical tree?

    yash_08031983
      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
          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
            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
              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