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