This discussion is archived
0 Replies Latest reply: Sep 29, 2013 8:54 PM by user1007 RSS

Error handling function: ORA-20001: get_dbms_sql_cursor error:ORA-00942: table or view does not exist  is not trapped. Why?

user1007 Newbie
Currently Being Moderated

Why APEX 4.1 Error handling function does not trap  the error of missing table?

Say, I create simple application with single IR report page and I also assign standard simple error handling function.

Function works perfectly, except but this case:

If I just drop a table used by report page and then refresh the page I am getting usual APEX error message:

ORA-20001: get_dbms_sql_cursor error ORA-00942: table or view does not exist

and error handling function is not invoked at all.

Is this a feature or a bug?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points