OWAPUB.HTP dependencies on DBMS_OUTPUT

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

723:
724: sp_loc integer;
725: nl_loc integer;
726: begin
727: /* First figure out how large to make the dbms_output buffer */
728: dbms_buf_size := (rows_in - rows_out)*255;
729: if (dbms_buf_size > 1000000)
730: then
731: dbms_output.enable(1000000);

Line 731: dbms_output.enable(1000000);

727: /* First figure out how large to make the dbms_output buffer */
728: dbms_buf_size := (rows_in - rows_out)*255;
729: if (dbms_buf_size > 1000000)
730: then
731: dbms_output.enable(1000000);
732: else
733: dbms_output.enable(dbms_buf_size);
734: end if;
735:

Line 733: dbms_output.enable(dbms_buf_size);

729: if (dbms_buf_size > 1000000)
730: then
731: dbms_output.enable(1000000);
732: else
733: dbms_output.enable(dbms_buf_size);
734: end if;
735:
736: /* Now, loop through, adding lines from htbuf, but */
737: /* never getting larger than 510 characters. */

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

756: then
757: sp_loc := instr(buffer, ' ', -1);
758: if (sp_loc = 0)
759: then
760: dbms_output.put_line(substr(buffer, 1, 255));
761: buffer := substr(buffer,256);
762: else
763: if (sp_loc <= 255)
764: then

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

761: buffer := substr(buffer,256);
762: else
763: if (sp_loc <= 255)
764: then
765: dbms_output.put_line(substr(buffer, 1, sp_loc - 1));
766: buffer := substr(buffer, sp_loc + 1);
767: else /* sp_loc > 255 */
768: dbms_output.put_line(substr(buffer, 1, 255));
769: buffer := substr(buffer, 256);

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

764: then
765: dbms_output.put_line(substr(buffer, 1, sp_loc - 1));
766: buffer := substr(buffer, sp_loc + 1);
767: else /* sp_loc > 255 */
768: dbms_output.put_line(substr(buffer, 1, 255));
769: buffer := substr(buffer, 256);
770: end if;
771: end if;
772: else

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

773: /* Always strip out the newlines */
774: /* PUT_LINE will put them in. */
775: if (nl_loc <= 255)
776: then
777: dbms_output.put_line(substr(buffer, 1, nl_loc - 1));
778: buffer := substr(buffer, nl_loc + 1);
779: else /* nl_loc > 255 */
780: dbms_output.put_line(substr(buffer, 1, 255));
781: buffer := substr(buffer, 256);

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

776: then
777: dbms_output.put_line(substr(buffer, 1, nl_loc - 1));
778: buffer := substr(buffer, nl_loc + 1);
779: else /* nl_loc > 255 */
780: dbms_output.put_line(substr(buffer, 1, 255));
781: buffer := substr(buffer, 256);
782: end if;
783: end if;
784: end loop;