SYS.PATCH_XDB$RESOURCE_T dependencies on DBMS_OUTPUT

Line 30: dbms_output.put_line('Patching XDB.XDB$RESOURCE_T');

26: patch_XDBHI := (found_XDBHI > 0) AND (patch_COBI OR patch_BV);
27:
28: -- decide whether XDB_RESOURCE_T needs patching
29: if (patch_COBI OR patch_BV OR patch_XDBHI) then
30: dbms_output.put_line('Patching XDB.XDB$RESOURCE_T');
31: else
32: dbms_output.put_line('No need to patch XDB.XDB$RESOURCE_T');
33: return;
34: end if;

Line 32: dbms_output.put_line('No need to patch XDB.XDB$RESOURCE_T');

28: -- decide whether XDB_RESOURCE_T needs patching
29: if (patch_COBI OR patch_BV OR patch_XDBHI) then
30: dbms_output.put_line('Patching XDB.XDB$RESOURCE_T');
31: else
32: dbms_output.put_line('No need to patch XDB.XDB$RESOURCE_T');
33: return;
34: end if;
35:
36: -- remove dependencies temporarily

Line 38: dbms_output.put_line(

34: end if;
35:
36: -- remove dependencies temporarily
37: if patch_XDBHI then
38: dbms_output.put_line(
39: ' Dropping index XDB.XDBHI_IDX on XDB.XDB_RESOURCE');
40: execute immediate 'drop index XDB.XDBHI_IDX';
41: end if;
42:

Line 45: dbms_output.put_line(

41: end if;
42:
43: -- patch CHECKEDOUTBYID
44: if patch_COBI then
45: dbms_output.put_line(
46: ' Patching attribute CHECKEDOUTBYID');
47: execute immediate
48: 'alter type XDB.XDB$RESOURCE_T drop attribute CHECKEDOUTBYID cascade';
49: execute immediate

Line 55: dbms_output.put_line(

51: end if;
52:
53: -- patch BASEVERSION
54: if patch_BV then
55: dbms_output.put_line(
56: ' Patching attribute BASEVERSION');
57: execute immediate
58: 'alter type XDB.XDB$RESOURCE_T drop attribute BASEVERSION cascade';
59: execute immediate

Line 65: dbms_output.put_line(

61: end if;
62:
63: -- restore dependencies
64: if patch_XDBHI then
65: dbms_output.put_line(
66: ' Re-creating index XDB.XDBHI_IDX on XDB.XDB_RESOURCE');
67: execute immediate
68: 'create index xdb.xdbhi_idx on xdb.xdb$resource p (value(p)) indextype is xdb.xdbhi_idxtyp';
69: end if;