begin declare procedure exec(p_stmt in varchar2) is begin execute immediate p_stmt; exception when others then dbms_output.put_line('===>' ||sqlcode || ' ' || sqlerrm); dbms_output.put_line(' ' || substr(p_stmt, 1, 250)); end; begin exec('drop table owbb_images'); --exec('drop table owbb_role_queries'); exec('drop table owbb_queries'); exec('drop table owbb_design_queries'); exec('drop table owbb_role_reports'); exec('drop table owbb_reports'); exec('drop sequence owbb_report_seq'); --exec('drop sequence owbb_favorites_seq'); --exec('drop table owbb_type_icons'); --exec('drop table owbb_type_bindings'); exec('drop table owbb_type_aliases'); exec('drop table owbb_types'); --exec('drop table owbb_app_renderers'); --exec('drop table owbb_app_repos_versions'); --exec('drop table owbb_applications'); --exec('drop sequence owbb_app_seq'); --exec('drop table owbb_roles'); --exec('drop table owbb_repos_types'); end; end;