eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_OBJECTS_UTILS dependencies on DBMS_OUTPUT

Line 21: dbms_output.put_line ('No type dictionary table to upgrade');

17: -- first make sure that there are dictionary tables in 8.0 format
18: execute immediate 'select bitand(flags, 128) from coltype$ where
19: obj#=(select obj# from obj$ where name=''KOTTD$'' and owner#=0)' into oldimg;
20: if (oldimg = 0) then
21: dbms_output.put_line ('No type dictionary table to upgrade');
22: return;
23: end if;
24:
25: execute immediate 'alter session set events ''22372 trace name

Line 30: dbms_output.put_line('Upgrading kottd$ ...');

26: context forever''';
27:
28: -- upgrade kottd$
29:
30: dbms_output.put_line('Upgrading kottd$ ...');
31: execute immediate 'create table kottd_temp$ of kottd';
32: execute immediate 'select count(*) from kottd$' into origcnt;
33: execute immediate 'insert into kottd_temp$(sys_nc_oid$, sys_nc_rowinfo$)
34: select sys_nc_oid$, sys_nc_rowinfo$ from kottd$';

Line 52: dbms_output.put_line('kottd$ Upgraded ...');

48: exception when others then null; end;';
49: execute immediate 'select count(*) from kottd$' into inscnt;
50: if(origcnt = inscnt) then
51: commit;
52: dbms_output.put_line('kottd$ Upgraded ...');
53: execute immediate 'drop table kottd_temp$';
54: else
55: dbms_output.put_line('Upgrade failed for kottd$ ...');
56: rollback;

Line 55: dbms_output.put_line('Upgrade failed for kottd$ ...');

51: commit;
52: dbms_output.put_line('kottd$ Upgraded ...');
53: execute immediate 'drop table kottd_temp$';
54: else
55: dbms_output.put_line('Upgrade failed for kottd$ ...');
56: rollback;
57: return;
58: end if;
59: -- now kottb$

Line 61: dbms_output.put_line('Upgrading kottb$ ...');

57: return;
58: end if;
59: -- now kottb$
60:
61: dbms_output.put_line('Upgrading kottb$ ...');
62: origcnt := 0;
63: inscnt := 0;
64:
65: execute immediate 'create table kottb_temp$ of kottb';

Line 84: dbms_output.put_line('kottb$ Upgraded ...');

80: others then null;end;';
81: execute immediate 'select count(*) from kottb$' into inscnt;
82: if(inscnt = origcnt) then
83: commit;
84: dbms_output.put_line('kottb$ Upgraded ...');
85: execute immediate 'drop table kottb_temp$';
86: else
87: dbms_output.put_line('Upgrade failed for kottb$ ...');
88: rollback;

Line 87: dbms_output.put_line('Upgrade failed for kottb$ ...');

83: commit;
84: dbms_output.put_line('kottb$ Upgraded ...');
85: execute immediate 'drop table kottb_temp$';
86: else
87: dbms_output.put_line('Upgrade failed for kottb$ ...');
88: rollback;
89: return;
90: end if;
91:

Line 95: dbms_output.put_line('Upgrading kottbx$ ...');

91:
92:
93: -- now kottbx$
94:
95: dbms_output.put_line('Upgrading kottbx$ ...');
96: origcnt := 0;
97: inscnt := 0;
98:
99: execute immediate 'create table kottbx_temp$ of kottbx';

Line 118: dbms_output.put_line('kottbx$ Upgraded ...');

114: others then null; end;';
115: execute immediate 'select count(*) from kottbx$' into inscnt;
116: if(inscnt = origcnt) then
117: commit;
118: dbms_output.put_line('kottbx$ Upgraded ...');
119: execute immediate 'drop table kottbx_temp$';
120: else
121: dbms_output.put_line('Upgrade failed for kottbx$ ...');
122: rollback;

Line 121: dbms_output.put_line('Upgrade failed for kottbx$ ...');

117: commit;
118: dbms_output.put_line('kottbx$ Upgraded ...');
119: execute immediate 'drop table kottbx_temp$';
120: else
121: dbms_output.put_line('Upgrade failed for kottbx$ ...');
122: rollback;
123: return;
124: end if;
125:

Line 127: dbms_output.put_line('Upgrading kotad$ ...');

123: return;
124: end if;
125:
126: -- now kotad$
127: dbms_output.put_line('Upgrading kotad$ ...');
128: origcnt := 0;
129: inscnt := 0;
130:
131: execute immediate 'create table kotad_temp$ of kotad';

Line 152: dbms_output.put_line('kotad$ Upgraded ...');

148: execute immediate 'select count(*) from kotad$' into inscnt;
149:
150: if(inscnt = origcnt) then
151: commit;
152: dbms_output.put_line('kotad$ Upgraded ...');
153: execute immediate 'drop table kotad_temp$';
154: else
155: dbms_output.put_line('Upgrade failed for kotad$ ...');
156: rollback;

Line 155: dbms_output.put_line('Upgrade failed for kotad$ ...');

151: commit;
152: dbms_output.put_line('kotad$ Upgraded ...');
153: execute immediate 'drop table kotad_temp$';
154: else
155: dbms_output.put_line('Upgrade failed for kotad$ ...');
156: rollback;
157: return;
158: end if;
159:

Line 163: dbms_output.put_line('Upgrading kotmd$ ...');

159:
160:
161: -- now kotmd$
162:
163: dbms_output.put_line('Upgrading kotmd$ ...');
164: origcnt := 0;
165: inscnt := 0;
166:
167: execute immediate 'create table kotmd_temp$ of kotmd';

Line 185: dbms_output.put_line('kotmd$ Upgraded ...');

181: then null; end;';
182: execute immediate 'select count(*) from kotmd$' into inscnt;
183: if(inscnt = origcnt) then
184: commit;
185: dbms_output.put_line('kotmd$ Upgraded ...');
186: execute immediate 'drop table kotmd_temp$';
187: else
188: dbms_output.put_line('Upgrade failed for kotmd$ ...');
189: rollback;

Line 188: dbms_output.put_line('Upgrade failed for kotmd$ ...');

184: commit;
185: dbms_output.put_line('kotmd$ Upgraded ...');
186: execute immediate 'drop table kotmd_temp$';
187: else
188: dbms_output.put_line('Upgrade failed for kotmd$ ...');
189: rollback;
190: return;
191: end if;
192:

Line 260: dbms_output.put_line ('kottd$ is in 8.0 image format');

256: -- first make sure that kottd$ is in 8.1 image format
257: execute immediate 'select bitand(flags, 128) from coltype$ where
258: obj#=(select obj# from obj$ where name=''KOTTD$'' and owner#=0)' into oldimg;
259: if (oldimg = 128) then
260: dbms_output.put_line ('kottd$ is in 8.0 image format');
261: return;
262: end if;
263:
264: -- event needed to create packed image typed tables