GET_BLOCK Error. Apex 18, mobile [SOLVED]

marussig

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

Carsten Czarski-Oracle

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 ...?

Best regards

-Carsten

Mahmoud_Rabie

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

marussig

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

Mahmoud_Rabie

I think it is a bug.

Please rename the thread title by adding [BUG] to get attention of APEX team.

Carsten Czarski-Oracle

Hi,

was that debug output taken from an APEX 18.1 instance ...?

And what is the Alias name of the application ...?

Best regards

-Carsten

marussig

Hi,

app name: Application 107 - iskram055

Yes debug output was taken from an APEX 18.1 instance

Thanks

Carsten Czarski-Oracle

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 ...?

Best regards

-Carsten

marussig

Hm... that's app alias:

F_1348921352961353191356821211571363221363881283511376111179841188256536792338122888126859150153155161162163165166168169170171174172175176177178179180189191193194195184185190196197198199200201202204205206207208209210211212213214215216217218219220116117157

I changed it and it works!!!

---

Summary: before copying should at least be checked app alias !

Thanks

Export is ok, import is ok

Carsten Czarski-Oracle

Hi,

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  

Best regards

-Carsten

marussig

That is right. I've made copies more times because of upgrades app.