Hello
I am trying to translate my application from english to german.
I use 'Session' for the parameter 'Application Language Derived From' in the Apex Globalization menu.
In the login process I use APEX_UTIL.SET_SESSION_LANG(P_LANG => 'de');. It work without problems when I create a small FOEX application for testing. But when I want to translate my larger application it fails with the following message:
Error in PLSQL code raised during plug-in processing.
Contact your application administrator.
Technical Info (only visible for developers)
-
is_internal_error: true
-
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
-
ora_sqlcode: -6502
-
ora_sqlerrm: ORA-06502: PL/SQL: numerischer oder Wertefehler: Fehler beim Konvertieren von Zeichen zu Zahl ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 1500 ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 2501 ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 136 ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 3103 ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 4902 ORA-06512: in "FOEX_040200.FX_P_UTILS", Zeile 4190 ORA-06512: in "FOEX_040200.FX_P_VIEWPORT", Zeile 206 ORA-06512: in "FOEX_040200.FX_P_VIEWPORT", Zeile 2603 ORA-06512: in Zeile 4 ORA-06512: in "SYS.DBMS_SYS_SQL", Zeile 2120 ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_190100", Zeile 599 ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 2486 ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 1476
-
component.type: APEX_APPLICATION_PAGE_REGIONS
-
component.id: 125432292760545223
-
component.name: Viewport
-
error_backtrace:
ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 136
ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 3103
ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 4902
ORA-06512: in "FOEX_040200.FX_P_UTILS", Zeile 4190
ORA-06512: in "FOEX_040200.FX_P_VIEWPORT", Zeile 206
ORA-06512: in "FOEX_040200.FX_P_VIEWPORT", Zeile 2603
ORA-06512: in Zeile 4
ORA-06512: in "SYS.DBMS_SYS_SQL", Zeile 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_190100", Zeile 599
ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 2486
ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 1500
ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 2501
ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 136
ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 3103
ORA-06512: in "FOEX_040200.FX_P_META_DATA", Zeile 4902
ORA-06512: in "FOEX_040200.FX_P_UTILS", Zeile 4190
ORA-06512: in "FOEX_040200.FX_P_VIEWPORT", Zeile 206
ORA-06512: in "FOEX_040200.FX_P_VIEWPORT", Zeile 2603
ORA-06512: in Zeile 4
ORA-06512: in "SYS.DBMS_SYS_SQL", Zeile 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_190100", Zeile 599
ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 2486
ORA-06512: in "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", Zeile 1476
ORA-06512: in "APEX_190100.WWV_FLOW_PLUGIN", Zeile 1351
-
error_statement:
begin declare
begin
wwv_flow_plugin_api.g_region_render_result := fx_p_viewport.render_plugin (p_region => wwv_flow_plugin_api.g_region,p_plugin => wwv_flow_plugin_api.g_plugin,p_is_printer_friendly => (:p_is_printer_friendly='Y') );end;
end;
I am not sure if its a Foex problem, but as the error has a lot of references to Foex I asume it might have something to do with it.
I tried to install a fresh copy of foex on my latop, but the same happens there too. Also I tried translating a very simple page in the app, but it still does not work and I get the same error.
Maybe you can help me with this or have a suggestion how I can track from where the error comes from so I can maybe fix it.
Thank you very much!