APPS.BIM_EDW_CMPSTATS_M_SIZE dependencies on DBMS_OUTPUT

Line 26: dbms_output.enable(1000000);

22:
23:
24: BEGIN
25:
26: dbms_output.enable(1000000);
27:
28: OPEN c_cnt_rows;
29: FETCH c_cnt_rows INTO p_num_rows;
30: CLOSE c_cnt_rows;

Line 32: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));

28: OPEN c_cnt_rows;
29: FETCH c_cnt_rows INTO p_num_rows;
30: CLOSE c_cnt_rows;
31:
32: dbms_output.put_line('The number of rows is: ' || to_char(p_num_rows));
33: END; -- procedure cnt_rows.
34:
35:
36: PROCEDURE est_row_len(p_from_date DATE,

Line 87: dbms_output.enable(1000000);

83:
84:
85: BEGIN
86:
87: dbms_output.enable(1000000);
88:
89: OPEN c_1;
90: FETCH c_1 INTO
91: x_NAME,

Line 128: -- dbms_output.put_line(' ');

124: x_total := x_total + 3*ceil(x_INSTANCE + 1);
125:
126: x_total := x_total + 15*(x_constant + 1);
127:
128: -- dbms_output.put_line(' ');
129: dbms_output.put_line('The average row length is : ' || to_char(x_total));
130:
131: p_avg_row_len := x_total;
132:

Line 129: dbms_output.put_line('The average row length is : ' || to_char(x_total));

125:
126: x_total := x_total + 15*(x_constant + 1);
127:
128: -- dbms_output.put_line(' ');
129: dbms_output.put_line('The average row length is : ' || to_char(x_total));
130:
131: p_avg_row_len := x_total;
132:
133: END; -- procedure est_row_len.