Execute dynamic SQL in multiple PDB

execute_sql_in_multiple_pdb.sql

declare
    c integer;
    r integer;
begin
    for rec in (select distinct con_name from v$active_services where con_id > 2 and lower(name) != lower(con_name)) loop
        c:= dbms_sql.open_cursor(security_level=>1);
        dbms_sql.parse(c=>c,
            statement=>'begin for rec in (select name from v$active_services where lower(name) != lower(con_name)) loop dbms_service.stop_service(service_name=>rec.name, stop_option=>''TRANSACTIONAL'', drain_timeout=>1); end loop; end;',
            language_flag=>dbms_sql.native,
            container=>rec.con_name);
        r:= dbms_sql.execute(c);
        dbms_sql.close_cursor(c);
    end loop;
end;
/