4 Replies Latest reply: May 7, 2013 8:33 AM by KarthikC RSS

    plugin tab menu  - ORA-06502: PL/SQL: numeric or value error

    KarthikC
      Hi All ,

      i import Tab menu and I want to use only the horizontal menu.
      http://www.apex-plugin.com/oracle-apex-plugins/odtug-competition/tab-menu_203.html

      I am getting following error.

      " Error in PLSQL code raised during plug-in processing.
      ORA-06502: PL/SQL: numeric or value error "

      this my account

      workspace : BUS_SOL
      username : test
      password : test123
      Application name test123

      I imported following component
      1.region_type_plugin_net_vanbaren_apex_tab_menu_v1.01.sql2 in plugin
      2.Theme_page_templates_A4.2.sql in theme
      3.Tabmenu_verticale.css in css

      I have no idea where I have to specify the tab and sub tab names.

      It will be really helpful . if some one help on this.
      Thank you
      Karthik
        • 1. Re: plugin tab menu  - ORA-06502: PL/SQL: numeric or value error
          Nicolette
          Karthik
          Karthik C wrote:
          I have no idea where I have to specify the tab and sub tab names.
          The parent and standard tabs are defined at Shared Components > Tabs.

          The basic idea of the plugin is to use the native tab concept of apex to make a "drop down" menu.
          For a "drop down" menu you have to have two levels. So parent tabs and standard tabs. (Shared components > tabs)

          The demo application you have in your apex.oracle.com workspace uses only one level of tabs (Only standard tabs). So the plugin will not work in this application.

          Unfortunately there is no way of a application that is set up for one level tabs to turn into a two level tabs application. So please set up a new two level tab application before we go in more detail of how to use the plugin.

          If you're going to use this plugin in a new applcation please please please start using lists instead of tabs.
          List give more options than tabs.
          List can have more than 2 levels. Tabs can have a maximum of 2 tabs and then only if you defined the application as 2 levels at creation.
          And swiching a sublist entry between parents is just setting a different parent for the entry. For the tabs you not only need to change the standerd tab but also the page it references.
          And in this case the most relevant there is already a drop down menu as list template. So there is no neason to use this plugin that needs isn't exactly plug and play.

          Nicolette
          • 2. Re: plugin tab menu  - ORA-06502: PL/SQL: numeric or value error
            KarthikC
            Hi Nic,
            I created a new application with two tab structure and I still getting the same error. Please let me know what wents wrong.
            New application name is test_tabing

            Thanks in advance
            Karthik
            • 3. Re: plugin tab menu  - ORA-06502: PL/SQL: numeric or value error
              Nicolette
              Karthik

              If you edit a parent tab (manage tabs click on the edit icon)
              You will see the following non update attributes
              Application:     15714 test_tabing
              Parent Tab Set:     main
              The tab set attribute of the plugin has to be exactly the same as the Parent Tab Set.

              Nicolette
              • 4. Re: plugin tab menu  - ORA-06502: PL/SQL: numeric or value error
                KarthikC
                Its working fine. Thanks a lot.