Workspace: FX_WS_1993
App: 648
Page: 1050
When setting a min value for a grid column, I can save the min value just fine - during entry Numbers and the decimal point are enterable, other characters are locked.
When running the page, however, I get an error message. In English:
is_internal_error: true
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
ora_sqlcode: -20100
ora_sqlerrm: ORA-20100: JSON Scanner exception @ line: 1 column: 43 - Unexpected char: . ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1500 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2501 ORA-06512: at "FOEX_040200.FX_P_JSON_PARSER", line 654 ORA-06512: at "FOEX_040200.FX_JSON_T", line 17 ORA-06512: at "FOEX_040200.FX_P_GRID", line 5578 ORA-06512: at "FOEX_040200.FX_P_GRID", line 5770 ORA-06512: at "FOEX_040200.FX_P_GRID", line 6267 ORA-06512: at "FOEX_040200.FX_P_GRID", line 6837 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 599 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2486 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1476
component.type: APEX_APPLICATION_PAGE_REGIONS
component.id: 204854020720644049
component.name: Data Types - Editors
error_backtrace:ORA-06512: at "FOEX_040200.FX_P_JSON_PARSER", line 654
ORA-06512: at "FOEX_040200.FX_JSON_T", line 17
ORA-06512: at "FOEX_040200.FX_P_GRID", line 5578
ORA-06512: at "FOEX_040200.FX_P_GRID", line 5770
ORA-06512: at "FOEX_040200.FX_P_GRID", line 6267
ORA-06512: at "FOEX_040200.FX_P_GRID", line 6837
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 599
ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2486
ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1500
ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2501
ORA-06512: at "FOEX_040200.FX_P_JSON_PARSER", line 654
ORA-06512: at "FOEX_040200.FX_JSON_T", line 17
ORA-06512: at "FOEX_040200.FX_P_GRID", line 5578
ORA-06512: at "FOEX_040200.FX_P_GRID", line 5770
ORA-06512: at "FOEX_040200.FX_P_GRID", line 6267
ORA-06512: at "FOEX_040200.FX_P_GRID", line 6837
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 599
ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2486
ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1476
ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 1351
error_statement:begin declare
begin
wwv_flow_plugin_api.g_region_render_result := fx_p_grid.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;
In German
s_internal_error: true
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
ora_sqlcode: -20101
ora_sqlerrm: ORA-20101: JSON Parser exception @ line: 1 column: 43 - Found , 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_JSON_PARSER", Zeile 469 ORA-06512: in "FOEX_040200.FX_P_JSON_PARSER", Zeile 610 ORA-06512: in "FOEX_040200.FX_P_JSON_PARSER", Zeile 657 ORA-06512: in "FOEX_040200.FX_JSON_T", Zeile 17 ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 5578 ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 5770 ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 6267 ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 6837 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: 204854020720644049
component.name: Data Types - Editors
error_backtrace:ORA-06512: in "FOEX_040200.FX_P_JSON_PARSER", Zeile 469
ORA-06512: in "FOEX_040200.FX_P_JSON_PARSER", Zeile 610
ORA-06512: in "FOEX_040200.FX_P_JSON_PARSER", Zeile 657
ORA-06512: in "FOEX_040200.FX_JSON_T", Zeile 17
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 5578
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 5770
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 6267
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 6837
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_JSON_PARSER", Zeile 469
ORA-06512: in "FOEX_040200.FX_P_JSON_PARSER", Zeile 610
ORA-06512: in "FOEX_040200.FX_P_JSON_PARSER", Zeile 657
ORA-06512: in "FOEX_040200.FX_JSON_T", Zeile 17
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 5578
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 5770
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 6267
ORA-06512: in "FOEX_040200.FX_P_GRID", Zeile 6837
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_grid.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 had expected to be able to enter a decimal min/max value and have it validate in Languages with period or comma as the decimal separators. Please have a look - thank you :-)
