ORA-604 and ORA-942 in APEX and ORDS

An unusual error from APEX and ORDS Two SQL statements on tables in the ORDS_METADATA schema failed with ORA-00604 and ORA-00942. The select statements were printed to the ORDS log together with: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist The two statements where almost the same, formatted below: SQL_ID: 3zuzjar8zcf9g select nvl(h.items_per_page,m.items_per_page) items_per_page, t.etag_type, t.etag_query, h.source_type, h.mle_env_name, m.origins_allowed, cursor( select p.name, p.bind_variable_name, p.source_type, p.access_method, p.param_type from ORDS_METADATA.user_ords_parameters p where p.handler_id = h.id) parameters, h.source from ORDS_METADATA.user_ords_modules m, ORDS_METADATA.user_ords_templates t, ORDS_METADATA.user_ords_handlers h where m.status = 'PUBLISHED' and t.id = h.template_id and m.id = t.module_id and h.id = :1 SQL_ID: 1pvaudrr9jh3w ...

November 18, 2026 · 4 min · Øyvind Isene

Moving ORDS from PDB to CDB

Oracle REST Data Services (ORDS) offers a seamless installation experience in the root container. By making a simple configuration adjustment, all pluggable databases can effortlessly be addressed, empowering users with enhanced functionality and convenience. Installing ORDS in the root container At one of my customers, Oracle Application Express (APEX) has been successfully deployed with Oracle REST Data Services (ORDS) running on Tomcat. However, ORDS was primarily utilized as a proxy for APEX in the database, with limited exploration of its broader capabilities. Typically, ORDS was installed within the pluggable database (PDB) as a natural choice. ...

October 4, 2023 · 3 min · Øyvind Isene

Show CGI Environment in APEX

This simple tip may help you troubleshooting integrations in APEX and ORDS. Show CGI Environment in APEX I have been struggling with integration issues in APEX lately. Listing out the CGI environment helped to identify the probable cause. Just create a region of type Dynamic Content and add this code: begin OWA_UTIL.PRINT_CGI_ENV; end; It will list values for HTTP_SERVER, HTTP_PORT, etc. If the configuration on your reverse proxy is wrong, it will likely show up here with values that will not work in the external world. ...

November 23, 2022 · 1 min · Øyvind Isene