Search code examples
oracle-databaseoracle-apexplsqldeveloperoracle-apex-20.2oracle-apex-20.1

Oracle APEX ORA-01722 when creating Interactive Report

I keep getting an ORA-01722 whenever I try to save the page. This happens when I try to:

  • Create a region as an Interactive Report: Tried 3 different tables, from the autmatic creation to typing the sql myself; With 1 or all columns; even doing a select 1 colX from dual;

  • Change any classic report to interactive report and click save.

  • If I create the interactive report from the template wizard, change to classic and try to move back, same issue.

  • I've already tried only varchar columns, disables all features from the IR, gave it static id and basically turned everything off and on again.

Solution

  • As of jun/20 the issue is on chromium. I had to use firefox and noticed it wasn't happening, tried on chrome and opera and it was also ok.