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.ODCIQUERYINFODUMP dependencies on DBMS_OUTPUT

Line 4: dbms_output.put_line('ODCIQueryInfo is null');

1: PROCEDURE ODCIQueryInfoDump(qi ODCIQueryInfo) IS
2: BEGIN
3: if qi is null then
4: dbms_output.put_line('ODCIQueryInfo is null');
5: return;
6: end if;
7:
8: dbms_output.put_line('ODCIQueryInfo');

Line 8: dbms_output.put_line('ODCIQueryInfo');

4: dbms_output.put_line('ODCIQueryInfo is null');
5: return;
6: end if;
7:
8: dbms_output.put_line('ODCIQueryInfo');
9: dbms_output.put_line('Flags :');
10:
11: IF (bitand(qi.Flags, ODCIConst.QueryFirstRows) > 0)
12: THEN

Line 9: dbms_output.put_line('Flags :');

5: return;
6: end if;
7:
8: dbms_output.put_line('ODCIQueryInfo');
9: dbms_output.put_line('Flags :');
10:
11: IF (bitand(qi.Flags, ODCIConst.QueryFirstRows) > 0)
12: THEN
13: dbms_output.put_line(' First Rows');

Line 13: dbms_output.put_line(' First Rows');

9: dbms_output.put_line('Flags :');
10:
11: IF (bitand(qi.Flags, ODCIConst.QueryFirstRows) > 0)
12: THEN
13: dbms_output.put_line(' First Rows');
14: END IF;
15:
16: IF (bitand(qi.Flags, ODCIConst.QueryAllRows) > 0)
17: THEN

Line 18: dbms_output.put_line(' All Rows');

14: END IF;
15:
16: IF (bitand(qi.Flags, ODCIConst.QueryAllRows) > 0)
17: THEN
18: dbms_output.put_line(' All Rows');
19: END IF;
20:
21: IF (bitand(qi.Flags, ODCIConst.QuerySortAsc) > 0)
22: THEN

Line 23: dbms_output.put_line(' Sort Ascending');

19: END IF;
20:
21: IF (bitand(qi.Flags, ODCIConst.QuerySortAsc) > 0)
22: THEN
23: dbms_output.put_line(' Sort Ascending');
24: END IF;
25:
26: IF (bitand(qi.Flags, ODCIConst.QuerySortDesc) > 0)
27: THEN

Line 28: dbms_output.put_line(' Sort Descending');

24: END IF;
25:
26: IF (bitand(qi.Flags, ODCIConst.QuerySortDesc) > 0)
27: THEN
28: dbms_output.put_line(' Sort Descending');
29: END IF;
30:
31: IF (bitand(qi.Flags, ODCIConst.QueryBlocking) > 0)
32: THEN

Line 33: dbms_output.put_line(' Blocking Operations');

29: END IF;
30:
31: IF (bitand(qi.Flags, ODCIConst.QueryBlocking) > 0)
32: THEN
33: dbms_output.put_line(' Blocking Operations');
34: END IF;
35:
36: IF qi.AncOps IS NOT NULL AND qi.AncOps.COUNT > 0 THEN
37: dbms_output.put_line('Ancillary Operators ');

Line 37: dbms_output.put_line('Ancillary Operators ');

33: dbms_output.put_line(' Blocking Operations');
34: END IF;
35:
36: IF qi.AncOps IS NOT NULL AND qi.AncOps.COUNT > 0 THEN
37: dbms_output.put_line('Ancillary Operators ');
38: FOR i IN qi.AncOps.FIRST..qi.AncOps.LAST LOOP
39: dbms_output.put_line(' Name : '||
40: qi.AncOps(i).ObjectName);
41: dbms_output.put_line(' Schema :'||

Line 39: dbms_output.put_line(' Name : '||

35:
36: IF qi.AncOps IS NOT NULL AND qi.AncOps.COUNT > 0 THEN
37: dbms_output.put_line('Ancillary Operators ');
38: FOR i IN qi.AncOps.FIRST..qi.AncOps.LAST LOOP
39: dbms_output.put_line(' Name : '||
40: qi.AncOps(i).ObjectName);
41: dbms_output.put_line(' Schema :'||
42: qi.AncOps(i).ObjectSchema);
43: END LOOP;

Line 41: dbms_output.put_line(' Schema :'||

37: dbms_output.put_line('Ancillary Operators ');
38: FOR i IN qi.AncOps.FIRST..qi.AncOps.LAST LOOP
39: dbms_output.put_line(' Name : '||
40: qi.AncOps(i).ObjectName);
41: dbms_output.put_line(' Schema :'||
42: qi.AncOps(i).ObjectSchema);
43: END LOOP;
44: END IF;
45:

Line 48: dbms_output.put_line('Pushed Down Predicates');

44: END IF;
45:
46:
47: IF qi.CompInfo IS NOT NULL AND qi.CompInfo.PredInfo IS NOT NULL THEN
48: dbms_output.put_line('Pushed Down Predicates');
49: FOR i IN qi.CompInfo.PredInfo.FIRST..qi.CompInfo.PredInfo.LAST LOOP
50: ODCIColInfoDump(qi.CompInfo.PredInfo(i).ColInfo);
51: dbms_output.put_line(' Flags: '||
52: qi.CompInfo.PredInfo(i).Flags);

Line 51: dbms_output.put_line(' Flags: '||

47: IF qi.CompInfo IS NOT NULL AND qi.CompInfo.PredInfo IS NOT NULL THEN
48: dbms_output.put_line('Pushed Down Predicates');
49: FOR i IN qi.CompInfo.PredInfo.FIRST..qi.CompInfo.PredInfo.LAST LOOP
50: ODCIColInfoDump(qi.CompInfo.PredInfo(i).ColInfo);
51: dbms_output.put_line(' Flags: '||
52: qi.CompInfo.PredInfo(i).Flags);
53: IF qi.CompInfo.PredInfo(i).strt IS NOT NULL THEN
54: dbms_output.put_line(' Start: ');
55: ODCIAnyDataDump(qi.CompInfo.PredInfo(i).strt);

Line 54: dbms_output.put_line(' Start: ');

50: ODCIColInfoDump(qi.CompInfo.PredInfo(i).ColInfo);
51: dbms_output.put_line(' Flags: '||
52: qi.CompInfo.PredInfo(i).Flags);
53: IF qi.CompInfo.PredInfo(i).strt IS NOT NULL THEN
54: dbms_output.put_line(' Start: ');
55: ODCIAnyDataDump(qi.CompInfo.PredInfo(i).strt);
56: END IF;
57: IF qi.CompInfo.PredInfo(i).stop IS NOT NULL THEN
58: dbms_output.put_line(' Stop: ');

Line 58: dbms_output.put_line(' Stop: ');

54: dbms_output.put_line(' Start: ');
55: ODCIAnyDataDump(qi.CompInfo.PredInfo(i).strt);
56: END IF;
57: IF qi.CompInfo.PredInfo(i).stop IS NOT NULL THEN
58: dbms_output.put_line(' Stop: ');
59: ODCIAnyDataDump(qi.CompInfo.PredInfo(i).stop);
60: END IF;
61:
62: END LOOP;

Line 66: dbms_output.put_line('Order By Clause');

62: END LOOP;
63: END IF;
64:
65: IF qi.CompInfo IS NOT NULL AND qi.CompInfo.ObyInfo IS NOT NULL THEN
66: dbms_output.put_line('Order By Clause');
67:
68: FOR i IN qi.CompInfo.ObyInfo.FIRST..qi.CompInfo.ObyInfo.LAST LOOP
69: dbms_output.put_line(' ExprType: '||
70: qi.CompInfo.ObyInfo(i).ExprType);

Line 69: dbms_output.put_line(' ExprType: '||

65: IF qi.CompInfo IS NOT NULL AND qi.CompInfo.ObyInfo IS NOT NULL THEN
66: dbms_output.put_line('Order By Clause');
67:
68: FOR i IN qi.CompInfo.ObyInfo.FIRST..qi.CompInfo.ObyInfo.LAST LOOP
69: dbms_output.put_line(' ExprType: '||
70: qi.CompInfo.ObyInfo(i).ExprType);
71: dbms_output.put_line(' Schema : '||
72: qi.CompInfo.ObyInfo(i).ObjectSchema);
73: dbms_output.put_line(' TableName : '||

Line 71: dbms_output.put_line(' Schema : '||

67:
68: FOR i IN qi.CompInfo.ObyInfo.FIRST..qi.CompInfo.ObyInfo.LAST LOOP
69: dbms_output.put_line(' ExprType: '||
70: qi.CompInfo.ObyInfo(i).ExprType);
71: dbms_output.put_line(' Schema : '||
72: qi.CompInfo.ObyInfo(i).ObjectSchema);
73: dbms_output.put_line(' TableName : '||
74: qi.CompInfo.ObyInfo(i).TableName);
75: dbms_output.put_line(' ColumnName : '||

Line 73: dbms_output.put_line(' TableName : '||

69: dbms_output.put_line(' ExprType: '||
70: qi.CompInfo.ObyInfo(i).ExprType);
71: dbms_output.put_line(' Schema : '||
72: qi.CompInfo.ObyInfo(i).ObjectSchema);
73: dbms_output.put_line(' TableName : '||
74: qi.CompInfo.ObyInfo(i).TableName);
75: dbms_output.put_line(' ColumnName : '||
76: qi.CompInfo.ObyInfo(i).ExprName);
77: dbms_output.put_line(' SortOrder : '||

Line 75: dbms_output.put_line(' ColumnName : '||

71: dbms_output.put_line(' Schema : '||
72: qi.CompInfo.ObyInfo(i).ObjectSchema);
73: dbms_output.put_line(' TableName : '||
74: qi.CompInfo.ObyInfo(i).TableName);
75: dbms_output.put_line(' ColumnName : '||
76: qi.CompInfo.ObyInfo(i).ExprName);
77: dbms_output.put_line(' SortOrder : '||
78: qi.CompInfo.ObyInfo(i).SortOrder);
79: END LOOP;

Line 77: dbms_output.put_line(' SortOrder : '||

73: dbms_output.put_line(' TableName : '||
74: qi.CompInfo.ObyInfo(i).TableName);
75: dbms_output.put_line(' ColumnName : '||
76: qi.CompInfo.ObyInfo(i).ExprName);
77: dbms_output.put_line(' SortOrder : '||
78: qi.CompInfo.ObyInfo(i).SortOrder);
79: END LOOP;
80: END IF;
81: END;