Running on Oracle 11g Release 22.214.171.124.0 Production
Running on APEX 4.1.1.00.23
Migrated from earlier version of Oracle and APEX 3.0 to ubove version, all went well.
Finally got around to wanting to add new TAB set. When I try to create a new TAB set or edit an existing one, I get an ERROR.
Application Builder -> <My_Appplication> -> Shared Components -> Tabs -> Manage Tabs => Error during rendering of region "Tab List". ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Anyone have any clue as to what I need to do to address this issue and get to the point where I can create/edit TABS?
I am disappointed that no one ever bothered to respond to this posting.
Makes me wonder where to go for help when I need it on APEX.
I decided to try and solve this myself, and I have.
Table APEX_040100.WWV_FLOW_TABS has a column TAB_ALSO_CURRENT_FOR_PAGES defomed as VARCHAR2(4000).
My application has over 250 pages, and each page with a tab is listed in this field in comma delimiited format.
Turns out APEX Manage Tabs page is only capable of rendering 223 pages. At 224 pages it overflows some parameter and generates the error: Error during rendering of region "Tab List". ORA-06502: PL/SQL: numeric or value error: character string buffer too small.
I created a view create view in my schema on APEX_WWV_FLOW_TABS as
SELECT FLOW_TAB, TAB_SET, TAB_TEXT, TAB_SEQUENCE, flow_id, TAB_ALSO_CURRENT_FOR_PAGES
WHERE FLOW_ID = 101;
My Applicaiton number is 101. I wanted to limiit the amount of damage I could do to must my app and not APEX as well.
As SYSTEM, I granted SELECT and UPDATE on this view to my schema.
Using APEX, I created a form with report on this view in my applicaiton, and then using this form started changing the number of page entries in the field TAB_ALSO_CURRENT_FOR_PAGES. Then going back to the APEX developer and seeing if I could get to Manage Tabs. I narowed it down to the exact number of pages that worked. The number of pages in my list was 229, but 6 of them do not have tabs, so the number of pages to render wass 223. If I upped the page number by one, I would get the Error message again
So to manage my tabs, I chop off most of the contents of this field (saving the original content for later), go to manage tabs, do whatever, and then go back and put back the list of pages in the TAB_ALSO_CURRENT_FOR_PAGES field using the form in my application.
Note, with a field length of varchar(4000), and page numbers of the form 'n', through 'nnnn,' there is a limit of 800 to 999 pages max with the same tab set for an application (as far as this field is concerned).
Also, by creating a new applicaiton using the APEX developer, I was able to get to the Manage Tab page just fine, as there were no pages with tabs at the outset. This indicated that APEX was capable of rendering this page, but not with the data it had for my app.
Not a pretty work-around, but better than nothing, which was where I was and getting no help.