plsql-sample-code/xtp.pks at main · mortenbra/plsql-sample-code · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
create or replace package xtp
as

  /*

  Purpose:    the neXT generation Plsql content builder

  Remarks:

  Date        Who  Description
  ----------  ---  -------------------------------------
  13.10.2022  MBR  Created

  */

  -- initialize buffer
  procedure init;

  -- print to buffer
  procedure p (p_text in varchar2);

  -- print to buffer without line feed
  procedure prn (p_text in varchar2);

  -- print clob to buffer
  procedure p (p_clob in clob);

  -- print clob to buffer without line feed
  procedure prn (p_clob in clob);

  -- get clob output
  function get_clob (p_clear_buffer in boolean := true) return clob;

end xtp;
/