dbms_utility.compile_schema compiles a user's schema. utl_recomp.recomp_serial alter session set plsql_warnings='enable:(6019, 6020, 6021, 6022)'; exec dbms_utility.compile_schema(schema => user) select * from user_errors;
dbms_utility.compile_schema cannot be called from a PL/SQL object in the schema that should be compiled with the call. In such a situation, this adaptable anonymous PL/SQL block ban be used to compile a given set of objects in a given schema.