Hi there,
I have created a simple application with a Data loading page. It works fine when I try to load data from file using ENGLISH version of the application (application language set to ENGLISH (en)).
When I switch application language to Lithuanian (lt) Data loading stops working. Application throws an error when I copy paste my data into a copy/paste text area on "Data Load Source" page and press the NEXT button to navigate to "Data / Table Mapping" page.
is_internal_error: true
apex_error_code: APEX.REGION.UNHANDLED_ERROR
original message: Error during rendering of region "Data / Table Mapping".
original_additional_info: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
component.type: APEX_APPLICATION_PAGES
component.id: 101000000066
component.name: Data / Table Mapping
error_backtrace:ORA-06512: at "APEX_050000.WWV_FLOW_DISP_PAGE_PLUGS", line 988
It does not matter what kind of data or how many rows I paste into copy/paste field. It could be varchar, number or any other type, it could be 1, 5 or 20 rows - the error occurs every time I press NEXT button on "Data Load Source" page.
If I switch the application language back to ENGLISH Data loading works fine again.
This issue occurs in APEX 5.0.3. Do not want to believe it is an APEX5 bug or maybe it is?
Have found few archived topics describing the same issue:
Unfortunately nobody has answered or throw any clue how to solve the problem.
Maybe someone had the same issue and had came with some kind of the solution? Any help or advice would be appreciate?