ORA-00942

[vieriParticipante]

===========================

Auditar errors na instância

create table
log (
dt date,
usr varchar2(30),
stmt varchar2(4000)
);

Table created.

create or replace trigger catch_error
after servererror on database
declare
l_text ora_name_list_t;
l_n number;
l_stmt varchar2(4000);
begin
l_n := ora_sql_txt( l_text );
for i in 1 .. nvl(l_text.count,0)
loop
l_stmt := l_text(i);
end loop;
l_stmt := l_stmt || ‘=> ‘;
for i in 1 .. ora_server_error_depth
loop
l_stmt := l_stmt || ora_server_error_msg(i);
end loop;
insert into log values ( sysdate, user, l_stmt );
end;
/

use com prudência!