DBA Data[Home] [Help]

SYS.DBMS_OBJECTS_APPS_UTILS dependencies on DBMS_OBJECTS_UTILS_TNAME

Line 358: names dbms_objects_utils_tnamearr) is

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
359: i number;
360: numtypes number;
361: temp number;
362: closec boolean := FALSE;

Line 363: typname dbms_objects_utils_tname;

359: i number;
360: numtypes number;
361: temp number;
362: closec boolean := FALSE;
363: typname dbms_objects_utils_tname;
364:
365: cursor c1 is
366: select 1 from sys.obj$ o,sys.type$ t1 ,sys.user$ u where o.oid$=t1.tvoid and
367: o.name=typname.typname and o.subname is NULL and o.OWNER# = USER# and