SYS.HTP dependencies on DBMS_OUTPUT

Line 1143: -- On DB version 10.2 and above, dbms_output buffer size can be unlimited

1139: i integer;
1140: sp_loc integer;
1141: nl_loc integer;
1142: begin
1143: -- On DB version 10.2 and above, dbms_output buffer size can be unlimited
1144: if require_db_version('10.2')
1145: then
1146: dbms_output.enable(buffer_size => NULL);
1147: else

Line 1146: dbms_output.enable(buffer_size => NULL);

1142: begin
1143: -- On DB version 10.2 and above, dbms_output buffer size can be unlimited
1144: if require_db_version('10.2')
1145: then
1146: dbms_output.enable(buffer_size => NULL);
1147: else
1148: /* First figure out how large to make the dbms_output buffer */
1149: dbms_buf_size := (rows_in - rows_out)*255*2;
1150: if (dbms_buf_size > 1000000)

Line 1148: /* First figure out how large to make the dbms_output buffer */

1144: if require_db_version('10.2')
1145: then
1146: dbms_output.enable(buffer_size => NULL);
1147: else
1148: /* First figure out how large to make the dbms_output buffer */
1149: dbms_buf_size := (rows_in - rows_out)*255*2;
1150: if (dbms_buf_size > 1000000)
1151: then
1152: dbms_output.enable(1000000);

Line 1152: dbms_output.enable(1000000);

1148: /* First figure out how large to make the dbms_output buffer */
1149: dbms_buf_size := (rows_in - rows_out)*255*2;
1150: if (dbms_buf_size > 1000000)
1151: then
1152: dbms_output.enable(1000000);
1153: else
1154: dbms_output.enable(dbms_buf_size);
1155: end if;
1156: end if;

Line 1154: dbms_output.enable(dbms_buf_size);

1150: if (dbms_buf_size > 1000000)
1151: then
1152: dbms_output.enable(1000000);
1153: else
1154: dbms_output.enable(dbms_buf_size);
1155: end if;
1156: end if;
1157:
1158:

Line 1189: dbms_output.put_line(substr(buffer, 1, 255));

1185: sp_loc := instr(substr(buffer,1,255), ' ', -1);
1186: if (sp_loc = 0)
1187: then
1188: /* Space not found. Write out the first 255 bytes as-is */
1189: dbms_output.put_line(substr(buffer, 1, 255));
1190:
1191: /* Update buffer to contain remaining bytes */
1192: buffer := substr(buffer,256);
1193: else

Line 1195: dbms_output.put_line(substr(buffer, 1, sp_loc - 1));

1191: /* Update buffer to contain remaining bytes */
1192: buffer := substr(buffer,256);
1193: else
1194: /* Space found. Write out bytes without the space */
1195: dbms_output.put_line(substr(buffer, 1, sp_loc - 1));
1196:
1197: /* Update buffer to contain remaining bytes */
1198: buffer := substr(buffer, sp_loc + 1);
1199: end if;

Line 1205: dbms_output.put_line(substr(buffer, 1, nl_loc - 1));

1201: /* Always strip out the newlines */
1202: /* PUT_LINE will put them in. */
1203:
1204: /* Newline found. Write out bytes without the newline */
1205: dbms_output.put_line(substr(buffer, 1, nl_loc - 1));
1206:
1207: /* Update buffer to contain remaining bytes */
1208: buffer := substr(buffer, nl_loc + 1);
1209: end if;