Friday, June 24, 2022

ORA-01722 While Creating new APEX Interactive Grid Or Interactive Report

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

Configure the Oracle DB Access Control List to avoid error like ORA-24247: network access denied

Symptoms:  You try to make external connections from the Oracle Database and receive erros like ORA-24247: network access denied by access c...