APEX

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!