CODEWITHSUNDEEP
oracle-databaseoracle-apexora-01722interactive-grid
Filip
Filip

Reputation: 1

Oracle APEX - ORA-01722: invalid number when saving Interactive report/Interactive grid

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.

I'm using Oracle APEX 22.2.0.

So there isn't problem with query. I tried with "select 1 from dual" or any other simple query. Then I saw suggested answers (2 years ago) and tried using Firefox. An it works.

What can I do to make it work on Chrome and Edge. Is this Oracle issue and it will be fixed with a new version?

Upvotes: 0

Views: 761

Answers (1)

Feike
Feike

Reputation: 1

This may be an older thread, but I recently had this issue as well.

The problem for me was in the default settings of the Grid, which included a dot (.) instead of a comma (,) as a decimal separator in the 'Border Width', found under the Printing tab on the right.

Changing the default '.5' to ',5' fixed it for me.

Upvotes: 0

Related Questions