-
Notifications
You must be signed in to change notification settings - Fork 1
/
nksg_tempclob.pks
74 lines (65 loc) · 3.44 KB
/
nksg_tempclob.pks
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
create or replace package nksg_tempclob
authid current_user
is
------------------------------------------------------------------
-- NKSG: PL/SQL Simple Generator
------------------------------------------------------------------
-- (c) Copyright 2017 Geraldo Viana (r4vrya@gmail.com)
--
-- Licensed under the Apache License, Version 2.0 (the "License"):
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
------------------------------------------------------------------
-- NKSG_TEMPCLOB: Temporary CLOBs with simpler API
------------------------------------------------------------------
------------------------------------------------------------------
------------------------ Declare Session -------------------------
------------------------------------------------------------------
------------------------------------------------------------------
----------------------- Subprogram Session -----------------------
------------------------------------------------------------------
------------------------------------------------------------------
-- NEW_PAYLOAD - Creates a new temporary CLOB
------------------------------------------------------------------
function new_payload
return pls_integer;
------------------------------------------------------------------
-- PAYLOAD_LENGTH - Returns the temporary CLOB length
------------------------------------------------------------------
function payload_length(fv_plid in pls_integer)
return integer;
------------------------------------------------------------------
-- PUT_PAYLOAD - Put data to a temporary CLOB
------------------------------------------------------------------
procedure put_payload(fv_plid in pls_integer,
fv_data in varchar2);
------------------------------------------------------------------
procedure put_payload(fv_plid in pls_integer,
fv_clob in clob);
------------------------------------------------------------------
-- GET_PAYLOAD - Retrieve payload
------------------------------------------------------------------
procedure get_payload(fv_plid in pls_integer,
fv_payload in out nocopy clob);
------------------------------------------------------------------
procedure get_payload(fv_plid in pls_integer,
fv_csid in integer default dbms_lob.default_csid,
fv_lang in integer default dbms_lob.default_lang_ctx,
fv_payload in out nocopy blob);
------------------------------------------------------------------
-- FREE - Drops the buffer and free resources
------------------------------------------------------------------
procedure free(fv_plid in pls_integer);
------------------------------------------------------------------
-- FREE_ALL - Drops all buffers in use for this session
------------------------------------------------------------------
procedure free_all;
end nksg_tempclob;