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

ORA-00942

When I had my first Oracle DBA course some years before the start of this millennium I made a special mental note about a very common error message, ORA-00942, “table or view does not exist”. In most programming languages there are a similar message for a common situation; when you refer to an object that does not exist, quite often because you wrote the name wrong. What I found a bit remarkable when I heard about it first time was that ORA-942 may mean two things, either that the table or view does indeed not exist, or you do not have access to it. An example of the latter is when some user has created a table in her schema, and you try to query it, but you have not been granted a privilege to do so. Instead of you receiving some error message like “access denied”, Oracle responds with the same error message; “table or view does not exist”, even if it does exist. It may have added “for you” to make it more correct. I think there is a good reason why this is so, and I think it has to do with optimisation. ...

May 16, 2015 · 3 min · Øyvind Isene

Removing orphan DataPump jobs and filtering included tables with a query

Say you define a DP job from the API (DBMS_DATAPUMP) you may end up with jobs with status NOT RUNNING until you get it right. Verify if you have such a job with select job_name,state from user_datapump_jobs; Then you may try to remove it with: declare l_h number; begin l_h:=dbms_datapump.attach('YOUR_JOB'); dbms_datapump.stop_job(l_h,immediate=>1); commit; end; / If the query above still reports the job with the same status it can be removed by dropping the master table, according to Note 336014.1: ...

November 20, 2010 · 2 min · Øyvind Isene