Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting ORA-06502: PL/SQL: numeric or value error: raw variable length too long when trying to

Brian WestonSep 2 2015 — edited Sep 2 2015

I have a APEX 3.2 application which I have imported into APEX 5. It imported OK and hopefully I followed the instructions correctly and would therefore assume I have, to a point, a APEX 5 application. I wanted to keep this import application as a base application so the first thing I tried was to make a new copy which I knew would be needed as the 3.2 version used APEXLIB. When I tried to copy the application I get the above error message which looking at WWV_FLOW_ACTIVITY_LOG1$ table I can see the SQLERRM_COMPONENT_TYPE is APEX_APPLICATION_PAGE_PROCESS and the SQLERRM_COMPONENT_NAME is 'copy application'.

Just in case I removed all references to APEXLIB and the modified 3.2 code runs OK but I still can not make a copy of it getting the same error.

I can see a trace file, which was created around the same time, and of which the following are some of the lines

*** MODULE NAME:(APEX_050000/APEX:APP 4000:1500) 2015-09-02 10:07:09.327

*** ACTION NAME:(Processes - point: BEFORE_BOX_BO) 2015-09-02 10:07:09.327

--------Dumping Sorted Master Trigger List --------

Trigger Owner : APEX_050000

Trigger Name : WWV_FLOW_PREFERENCES_T1

but I do not know if they are related.


For information, I did initially look at converting this application to APEX 4.2 a few months ago. I could copy the application OK but we decided to stop  going any further as APEX 5 was released and on reading various blogs and articles, the general census was that it was best to try and go from 3.2 to 5 as there were changes that would be need in going from 4 to 5. As the application did copy I therefore believe something in APEX 5 is stopping me from doing it .

I am now at a bit lost as to where I can go next to investigate the issue further. Is there further logging I can check or turn on? Are there some limitations like the length of component names in APEX 5 which were not there for Apex 3 or 4?

A bit more background. I did not create the application originally but took on the maintenance and support of it. It is not the main part of my work and therefore my knowledge is limited. I have never created an application from scratch apart from the ones in the training material. I do try to keep up to date with whats new in APEX 5 but as you will appreciate there as been quite a lot written in the last few months.

If anyone knows what the issue could be or could point me in the direction of where I can find more information I would appreciate the help.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 30 2015
Added on Sep 2 2015
3 comments
648 views