Symptoms:
While trying to create new Interactive Grids or Interactive Reports in APEX applications, everything works as expected until the SAVE button is clicked and the following error message is displayed:
ORA-01722: invalid number
The problem appears to be only with Save but not with the query during runtime.
Cause:
The issue appears due to the reason that the action is being performed through a language other than English through the browser plugin.
Solution:
Append the string &p_lang=en to the URL in the browser address bar
Reload the page designer and test the behavior.
In order to get rid of this error, Customer need to install the language components for the corresponding language.
And belive, it works!
Source: ORA-01722 While Creating new Interactive Grid Or Interactive Report (MOS Doc ID 2859399.1)
No comments:
Post a Comment