DBA Data[Home] [Help]

SYS.DBMS_OBJECTS_APPS_UTILS dependencies on UTL_RECOMP

Line 354: -- table dependents. Afterwards this will call utl_recomp.recomp_parallel

350: -- This procedure will take in an array (nested table) of type name and
351: -- invalidate them with status 6. This status will keep the spec timestamp
352: -- when recompiling, this keeping the dependencies valid. This is used during
353: -- upgrade/downgrade predominently and the only way to recompile a type with
354: -- table dependents. Afterwards this will call utl_recomp.recomp_parallel
355: -- to revalidate the invalidated types.
356:
357: procedure recompile_types(
358: names dbms_objects_utils_tnamearr) is

Line 408: utl_recomp.recomp_parallel(null);

404: -- clear SGA
405: execute immediate 'alter system flush shared_pool';
406:
407: -- now recompile
408: utl_recomp.recomp_parallel(null);
409:
410: /*
411: for i in names.first .. names.last loop
412: typname := names(i);