create or replace procedure pr_error_table_chk as
v_count number;
cursor c1 is select table_name from all_tab where table_name like 'ERR$_%';
r_tab c1%rowtype;
begin
loop
fetch c1 into r_tab;
exit when c1%notfound;
select count(*) into v_count from r_tab.table_name;
if v_count > 0 then
dbms_output.put_line ('Table_Name' || ' ' || r_tab.table_name );
end if;
end loop;
end;
