code_junkie

ORA-00942: table or view does not exist : How do I find which table or view it is talking about

Nov 11th, 2011
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. create table caught_errors (
  2. dt date,
  3. username varchar2( 30), -- value from ora_login_user
  4. msg varchar2(2000),
  5. stmt varchar2(2000)
  6. );
  7.  
  8.  
  9. create or replace trigger catch_errors
  10. after servererror on database
  11. declare
  12. sql_text ora_name_list_t;
  13. msg_ varchar2(2000) := null;
  14. stmt_ varchar2(2000) := null;
  15. begin
  16.  
  17. for depth in 1 .. ora_server_error_depth loop
  18. msg_ := msg_ || ora_server_error_msg(depth);
  19. end loop;
  20.  
  21. for i in 1 .. ora_sql_txt(sql_text) loop
  22. stmt_ := stmt_ || sql_text(i);
  23. end loop;
  24.  
  25. insert into
  26. caught_errors (dt , username ,msg ,stmt )
  27. values (sysdate, ora_login_user,msg_,stmt_);
  28. end;
  29. /
Add Comment
Please, Sign In to add comment