begin 

declare
	procedure exec(p_stmt in varchar2)
	is
	begin
		execute immediate p_stmt;
	exception
		when others then
      dbms_output.put_line('===>' ||sqlcode || ' ' || sqlerrm);
			return;
  end;
begin

	exec('drop sequence wmp_repository_seq');
	exec('drop table wmp_repositories cascade constraints');
	exec('drop table wmp_group_repositories cascade constraints');
	exec('drop table wmp_user_repositories cascade constraints');
	exec('drop table wmp_roles cascade constraints');
	exec('drop table wmp_group_roles cascade constraints');
	exec('drop table wmp_user_roles cascade constraints');
	exec('drop table wmp_group_portlets cascade constraints');
	exec('drop table wmp_user_portlets cascade constraints');
	exec('drop table wmp_types cascade constraints');
	exec('drop table wmp_type_aliases cascade constraints');
	exec('drop table wmp_images cascade constraints');
	exec('drop table wmp_queries cascade constraints');
	exec('drop table wmp_role_queries cascade constraints');
	exec('drop sequence wmp_custom_report_seq');
	exec('drop table wmp_reports cascade constraints');
	exec('drop table wmp_role_reports cascade constraints');
	exec('drop sequence wmp_favorites_seq');
	exec('drop table wmp_navigation_favorites cascade constraints');
	exec('drop table wmp_report_favorites cascade constraints');
	exec('drop table wmp_binary_docs cascade constraints');
	exec('drop table wmp_text_docs cascade constraints');
	exec('drop table wmp_errors cascade constraints');
	exec('drop table wmp_preferences cascade constraints');
	exec('drop table lia_xml_table2 cascade constraints');
	exec('drop table lia_refresh_log cascade constraints');
	exec('drop sequence wmp_links_seq');
	exec('drop table wmp_links cascade constraints');
	exec('drop view WMP_ACCESSIBLE_REPOSITORIES');
	exec('drop view WMP_ACCESSIBLE_ROLES');
	exec('drop table wmp_nls');
	exec('drop table wmp_migration_log');
	exec('drop sequence wmp_migration_log_seq');
	exec('drop table wmp_extended_properties');
	exec('drop view WMP_db_links_v');
  --|Client version
	exec('drop table wwnls_strings$');
end; 
end;