declare l_id number := 0; begin /* for r in (select id from ~portalSchema.wwnls_strings$ where domain = 'wm' and name like '~userSchema.%') loop begin l_id := ~portalSchema.wwnls_api.remove_string(r.id, true); exception when others then null; end; end loop; */ execute immediate ' declare l_id number := 0; begin for r in (select id from ~portalSchema.wwnls_strings$ where domain = ''wm'' and name like ''~userSchema.%'') loop begin l_id := ~portalSchema.wwnls_api.remove_string(r.id, true); exception when others then null; end; end loop; exception when others then null; end; '; exception when others then null; end;