-
Notifications
You must be signed in to change notification settings - Fork 18
/
lobdeclaration.html
134 lines (102 loc) · 3.55 KB
/
lobdeclaration.html
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Mon Mar 18 08:51:05 2024 -->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="generator" content="groff -Thtml, see www.gnu.org">
<meta http-equiv="Content-Type" content="text/html; charset=US-ASCII">
<meta name="Content-Style" content="text/css">
<style type="text/css">
p { margin-top: 0; margin-bottom: 0; vertical-align: top }
pre { margin-top: 0; margin-bottom: 0; vertical-align: top }
table { margin-top: 0; margin-bottom: 0; vertical-align: top }
h1 { text-align: center }
</style>
<title>lobdeclaration</title>
</head>
<body>
<h1 align="center">lobdeclaration</h1>
<a href="#NAME">NAME</a><br>
<a href="#SYNTAX">SYNTAX</a><br>
<a href="#DESCRIPTION">DESCRIPTION</a><br>
<a href="#USAGE">USAGE</a><br>
<a href="#EXAMPLE">EXAMPLE</a><br>
<a href="#COPYRIGHT">COPYRIGHT</a><br>
<a href="#SEE ALSO">SEE ALSO</a><br>
<hr>
<h2>NAME
<a name="NAME"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">lobdeclaration
− RWP*Load Simulator declare LOB locator</p>
<h2>SYNTAX
<a name="SYNTAX"></a>
</h2>
<pre style="margin-left:11%; margin-top: 1em">lobdeclaration ::=
[<b> private</b> ]<b> clob</b> identifier {<b> ,</b> identifier }</pre>
<h2>DESCRIPTION
<a name="DESCRIPTION"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">A clob is
declared in the same ways scalars are, and they can be
publicly, private or local inside a procedure or
function.</p>
<h2>USAGE
<a name="USAGE"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">A clob is
effectively like an OCILobLocator in Oracle Call Interface,
and it must therefore be used like you would use them in a C
program. Among other things, this means you must select the
lob from a table before it can be used with the
<b>readlob</b> or <b>writelob</b> statements.</p>
<p style="margin-left:11%; margin-top: 1em">Rwloadsim
currently operates on complete lobs only and all data in the
lob will be read or written at once; there is no support for
piece wise reading or writing. This sets a practical limit
to the size as all data need to be allocated in memory.
Effectively, sizes up to megabytes can surely be handled
while sizes in the order or gigabytes for all practical
purposes cannot. The actual limit will depend on the
available memory.</p>
<h2>EXAMPLE
<a name="EXAMPLE"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The following
code snippet shows how you can use a clob to insert lob data
into a table.</p>
<pre style="margin-left:17%; margin-top: 1em">string (1000000) mydata;
clob mylob; integer myid;
sql insnewlob
begin
-- first create the new row with an empty clob
insert into mytable(id,cl)
values (mysequence.nextval, empty_clob())
returning id into :1;
-- then select the lob locator
select cl into :2 from mytable
where id = :1;
end;
/
bindout 1 myid, 2 mylob;
end;
mydata := ... # Assign some text to this string
insnewlob; # Execute the PL/SQL block
writelob mylob, mydata; # Write the data
commit;</pre>
<h2>COPYRIGHT
<a name="COPYRIGHT"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">Copyright
© 2023 Oracle Corporation <br>
Licensed under the Universal Permissive License v 1.0 as
shown at https://oss.oracle.com/licenses/upl</p>
<h2>SEE ALSO
<a name="SEE ALSO"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><a href="simpledeclaration.html">simpledeclaration(1rwl)</a>,
<a href="databasestatement.html">databasestatement(1rwl)</a></p>
<hr>
</body>
</html>