declare l_prov_rec wwpro_api_provider_registry.node_provider_record; l_prov_id integer; begin l_prov_rec := wwpro_api_provider_registry.find_provider(upper('~userSchema') || '_Provider', 'us'); l_prov_id := l_prov_rec.id; wwpro_api_provider_registry.deregister_provider(l_prov_id); wwpro_api_provider_registry.deregister_provider('~userSchema'); exception when others then null; end;