This discussion is archived
4 Replies Latest reply: May 7, 2013 6:33 AM by KarthikC RSS

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

KarthikC Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Its working fine. Thanks a lot.

Legend

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