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!
I simply can not copy app. This couldn't be nothing like bug. Does anyone has some idea what/where/how to report an error/bug? I'm using revion.com platform, and team suggest me to report it. We tried this on APEX 5 and APEX 18.
Thanks
Hi Marussig
APEX 18.1 has an easy way to debug
Dimitri Gielis Blog (Oracle Application Express - APEX): Error!?! What's going in APEX? The easiest way to Debug and Tra…
In addition, you could make the ORA errors appear friendly
How to provide user friendly messages for ORA errors
I hope that helps
Regards
Mahmoud
Thanks. The problem persist and is not in my app. I think I need to create a bug report somewhere. This "- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small" raise somewhere from system plsql package on copy app. Do you have some more recommendations? Otherwise my app runs fine.
Thanks again
- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APEX_180100.WWV_FLOW_APPLICATION_INSTALL", line 267
ORA-06512: at "APEX_180100.WWV_FLOW_IMP_PARSER", line 1397
I think it is a bug.
Please rename the thread title by adding [BUG] to get attention of APEX team.
Hi,
was that debug output taken from an APEX 18.1 instance ...?
And what is the Alias name of the application ...?
Best regards
-Carsten
app name: Application 107 - iskram055
Yes debug output was taken from an APEX 18.1 instance
HI,
OK - the error stack you have shared indicates that something is not OK with the Application Alias ...
-) Can you export the app ...?
-) Can you import it back ...?
-) What happens if you clear the Application Alias field before copying ...?
Hm... that's app alias:
F_1348921352961353191356821211571363221363881283511376111179841188256536792338122888126859150153155161162163165166168169170171174172175176177178179180189191193194195184185190196197198199200201202204205206207208209210211212213214215216217218219220116117157
I changed it and it works!!!
---
Summary: before copying should at least be checked app alias !
Export is ok, import is ok
the Application Alias is limited to 255 characters. And when an application is being copied and the Alias does not equal the application ID, then the new application ID is appended to the existing alias. Looking at your alias, it seems that this application has been copied quite a few times.
The final copy operation would then extend the alias to more than 255 characters thus we see that error ... a corner case, but an interesting one
That is right. I've made copies more times because of upgrades app.
