Hi,
I realize this is an ORDS question but I figure APEX gurus might be the best people to ask. We've upgraded to ORDS 20.3 on Oracle 19c and APEX 20.2 all running on Oracle Linux 8. We have a REST API that has been working fine on this installation yet suddenly it has started generating the following internal server error:
select nvl(h.items_per_page,m.items_per_page) items_per_page, t.etag_type, t.etag_query, h.source_type, m.origins_allowed, cursor(select p.name, p.bind_variable_name, p.source_type,p.access_method, p.param_type from user_ords_parameters p where p.handler_id = h.id) parameters, h.source from user_ords_modules m, user_ords_templates t, user_ords_handlers h where m.status = 'PUBLISHED' and t.id = h.template_id and m.id = t.module_id and h.id = :1 , OriginalSql = select nvl(h.items_per_page,m.items_per_page) items_per_page, t.etag_type, t.etag_query, h.source_type, m.origins_allowed, cursor(select p.name, p.bind_variable_name, p.source_type,p.access_method, p.param_type from user_ords_parameters p where p.handler_id = h.id) parameters, h.source from user_ords_modules m, user_ords_templates t, user_ords_handlers h where m.status = 'PUBLISHED' and t.id = h.template_id and m.id = t.module_id and h.id = ?, Error Msg = ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Under the same RESTful Service Module I created a test handler (simply returning "select 'test' from dual") and this produces the same error.
Has anyone encountered this?
Kind regards,
Barry