DBA Data[Home] [Help]

SYS.DBMS_OBJECTS_APPS_UTILS dependencies on DBMS_OUTPUT

Line 190: dbms_output.put_line('Type ' || ltinfo.name ||

186:
187: <>
188: if (allgood = 0) then
189: -- ah, the hashcode check failed ...
190: dbms_output.put_line('Type ' || ltinfo.name ||
191: ' failed structural sanity check');
192: end if;
193:
194: allgood := 1;

Line 199: dbms_output.put_line('Versions do not match for type ' || ltinfo.name);

195:
196: <>
197: if (allgood = 0) then
198: -- version mismatch ...
199: dbms_output.put_line('Versions do not match for type ' || ltinfo.name);
200: end if;
201:
202: allgood := 1;
203:

Line 207: dbms_output.put_line('Not all tables/columns dependent on ' ||

203:
204: <>
205: if (allgood = 0) then
206: -- not all columns/tables updated
207: dbms_output.put_line('Not all tables/columns dependent on ' ||
208: schema1 || ' updated');
209: end if;
210:
211: exception

Line 214: dbms_output.put_line('Error updating dictionary');

210:
211: exception
212: when others then
213: if (allgood = 1) then
214: dbms_output.put_line('Error updating dictionary');
215: end if;
216: raise;
217:
218: end; /* end of procedure update types */

Line 341: -- dbms_output.put_line('* ' || to_char(j) || ' : ' ||

337: close c3;
338:
339: -- print out the type sources
340: -- for j in 1..i loop
341: -- dbms_output.put_line('* ' || to_char(j) || ' : ' ||
342: -- sources(j).objid || ' ' || sources(j).source);
343: -- end loop;
344:
345: return i;

Line 380: dbms_output.put_line('Processing ' || typname.schema || '.' ||

376: close c1;
377: end if;
378: closec := TRUE;
379: typname := names(i);
380: dbms_output.put_line('Processing ' || typname.schema || '.' ||
381: typname.typname);
382: -- see if this one is in vsn 1 hashcode
383: open c1;
384: fetch c1 into temp;

Line 391: dbms_output.put_line('Invalidating ' || typname.schema || '.' ||

387: closec := FALSE;
388:
389: -- increment the count of types invalidated
390: numtypes := numtypes+1;
391: dbms_output.put_line('Invalidating ' || typname.schema || '.' ||
392: typname.typname);
393: update obj$ set status=6 where type#=13 and subname is null and
394: name=typname.typname and owner#=(select user# from user$ where
395: name=typname.schema);