German (or any Other Language) Translation for an APEX Application - ORA-06502 Error On Web Services (Doc ID 2190538.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.3.00.03 and later
Information in this document applies to any platform.

Symptoms

An application, developed in English, uses Restful Web Services to get and send data to remote data sources.
- Created a German translation application using the Translate Application feature in Shared Components.
- Seeded the data from the main application 1000 into a German sub application 1011.
- Uploaded two pages that have been translated using the XLIFF files. Applied them and published it.

Using the FSP_LANGUAGE PREFERENCE application item to set the language, and it works correctly. The pages change from English to German when set the Application Item.
However, whenever it runs one of the Web Services, it seems to produce an ORA-06502 character to number conversion error.
Because user validation is done using a Web Service, no German users can log in.
When logged in as an English user and navigate to another translated page, the Web Services error out there as well when switching to German.

The main issue is the login script which uses a Web Service to validate username and password from a remote database. When user logs in on an English translation of the page, it validates, when he uses the same credentials on
the German page, it doesn't. If he tries logging in using the English page and then switch to German, the errors he gets are related to the Web Service references. The validation does not involve any date or number parameters,
just username and password.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms