[Home] [Help]
PACKAGE: SYS.LCR$_XML_SCHEMA
Source
1 package lcr$_xml_schema as
2
3 CONFIGURL VARCHAR2(2000) :=
4 'http://xmlns.oracle.com/streams/schemas/lcr/streamslcr.xsd';
5 CONFIGXSD_10101 VARCHAR2(20000) :=
6 '<schema xmlns="http://www.w3.org/2001/XMLSchema"
7 targetNamespace="http://xmlns.oracle.com/streams/schemas/lcr"
8 xmlns:lcr="http://xmlns.oracle.com/streams/schemas/lcr"
9 xmlns:xdb="http://xmlns.oracle.com/xdb"
10 version="1.0"
11 elementFormDefault="qualified">
12
13 <simpleType name = "short_name">
14 <restriction base = "string">
15 <maxLength value="30"/>
16 </restriction>
17 </simpleType>
18
19 <simpleType name = "long_name">
20 <restriction base = "string">
21 <maxLength value="4000"/>
22 </restriction>
23 </simpleType>
24
25 <simpleType name = "db_name">
26 <restriction base = "string">
27 <maxLength value="128"/>
28 </restriction>
29 </simpleType>
30
31 <!-- Default session parameter is used if format is not specified -->
32 <complexType name="datetime_format">
33 <sequence>
34 <element name = "value" type = "string" nillable="true"/>
35 <element name = "format" type = "string" minOccurs="0" nillable="true"/>
36 </sequence>
37 </complexType>
38
39 <complexType name="anydata">
40 <choice>
41 <element name="varchar2" type = "string" xdb:SQLType="CLOB"
42 nillable="true"/>
43
44 <!-- Represent char as varchar2. xdb:CHAR blank pads upto 2000 bytes! -->
45 <element name="char" type = "string" xdb:SQLType="CLOB"
46 nillable="true"/>
47 <element name="nchar" type = "string" xdb:SQLType="NCLOB"
48 nillable="true"/>
49
50 <element name="nvarchar2" type = "string" xdb:SQLType="NCLOB"
51 nillable="true"/>
52 <element name="number" type = "double" xdb:SQLType="NUMBER"
53 nillable="true"/>
54 <element name="raw" type = "hexBinary" xdb:SQLType="BLOB"
55 nillable="true"/>
56 <element name="date" type = "lcr:datetime_format"/>
57 <element name="timestamp" type = "lcr:datetime_format"/>
58 <element name="timestamp_tz" type = "lcr:datetime_format"/>
59 <element name="timestamp_ltz" type = "lcr:datetime_format"/>
60
61 <!-- Interval YM should be as per format allowed by SQL -->
62 <element name="interval_ym" type = "string" nillable="true"/>
63
64 <!-- Interval DS should be as per format allowed by SQL -->
65 <element name="interval_ds" type = "string" nillable="true"/>
66
67 <element name="urowid" type = "string" xdb:SQLType="VARCHAR2"
68 nillable="true"/>
69 </choice>
70 </complexType>
71
72 <complexType name="column_value">
73 <sequence>
74 <element name = "column_name" type = "lcr:long_name" nillable="false"/>
75 <element name = "data" type = "lcr:anydata" nillable="false"/>
76 <element name = "lob_information" type = "string" minOccurs="0"
77 nillable="true"/>
78 <element name = "lob_offset" type = "nonNegativeInteger" minOccurs="0"
79 nillable="true"/>
80 <element name = "lob_operation_size" type = "nonNegativeInteger"
81 minOccurs="0" nillable="true"/>
82 <element name = "long_information" type = "string" minOccurs="0"
83 nillable="true"/>
84 </sequence>
85 </complexType>
86
87 <complexType name="extra_attribute">
88 <sequence>
89 <element name = "attribute_name" type = "lcr:short_name"/>
90 <element name = "attribute_value" type = "lcr:anydata"/>
91 </sequence>
92 </complexType>
93
94 <element name = "ROW_LCR" xdb:defaultTable="">
95 <complexType>
96 <sequence>
97 <element name = "source_database_name" type = "lcr:db_name"
98 nillable="false"/>
99 <element name = "command_type" type = "string" nillable="false"/>
100 <element name = "object_owner" type = "lcr:short_name"
101 nillable="false"/>
102 <element name = "object_name" type = "lcr:short_name"
103 nillable="false"/>
104 <element name = "tag" type = "hexBinary" xdb:SQLType="RAW"
105 minOccurs="0" nillable="true"/>
106 <element name = "transaction_id" type = "string" minOccurs="0"
107 nillable="true"/>
108 <element name = "scn" type = "double" xdb:SQLType="NUMBER"
109 minOccurs="0" nillable="true"/>
110 <element name = "old_values" minOccurs = "0">
111 <complexType>
112 <sequence>
113 <element name = "old_value" type="lcr:column_value"
114 maxOccurs = "unbounded"/>
115 </sequence>
116 </complexType>
117 </element>
118 <element name = "new_values" minOccurs = "0">
119 <complexType>
120 <sequence>
121 <element name = "new_value" type="lcr:column_value"
122 maxOccurs = "unbounded"/>
123 </sequence>
124 </complexType>
125 </element>
126 <element name = "extra_attribute_values" minOccurs = "0">
127 <complexType>
128 <sequence>
129 <element name = "extra_attribute_value"
130 type="lcr:extra_attribute"
131 maxOccurs = "unbounded"/>
132 </sequence>
133 </complexType>
134 </element>
135 </sequence>
136 </complexType>
137 </element>
138
139 <element name = "DDL_LCR" xdb:defaultTable="">
140 <complexType>
141 <sequence>
142 <element name = "source_database_name" type = "lcr:db_name"
143 nillable="false"/>
144 <element name = "command_type" type = "string" nillable="false"/>
145 <element name = "current_schema" type = "lcr:short_name"
146 nillable="false"/>
147 <element name = "ddl_text" type = "string" xdb:SQLType="CLOB"
148 nillable="false"/>
149 <element name = "object_type" type = "string"
150 minOccurs = "0" nillable="true"/>
151 <element name = "object_owner" type = "lcr:short_name"
152 minOccurs = "0" nillable="true"/>
153 <element name = "object_name" type = "lcr:short_name"
154 minOccurs = "0" nillable="true"/>
155 <element name = "logon_user" type = "lcr:short_name"
156 minOccurs = "0" nillable="true"/>
157 <element name = "base_table_owner" type = "lcr:short_name"
158 minOccurs = "0" nillable="true"/>
159 <element name = "base_table_name" type = "lcr:short_name"
160 minOccurs = "0" nillable="true"/>
161 <element name = "tag" type = "hexBinary" xdb:SQLType="RAW"
162 minOccurs = "0" nillable="true"/>
163 <element name = "transaction_id" type = "string"
164 minOccurs = "0" nillable="true"/>
165 <element name = "scn" type = "double" xdb:SQLType="NUMBER"
166 minOccurs = "0" nillable="true"/>
167 <element name = "extra_attribute_values" minOccurs = "0">
168 <complexType>
169 <sequence>
170 <element name = "extra_attribute_value"
171 type="lcr:extra_attribute"
172 maxOccurs = "unbounded"/>
173 </sequence>
174 </complexType>
175 </element>
176 </sequence>
177 </complexType>
178 </element>
179 </schema>';
180
181 CONFIGXSD_9204 VARCHAR2(20000) :=
182 '<schema xmlns="http://www.w3.org/2001/XMLSchema"
183 targetNamespace="http://xmlns.oracle.com/streams/schemas/lcr"
184 xmlns:lcr="http://xmlns.oracle.com/streams/schemas/lcr"
185 xmlns:xdb="http://xmlns.oracle.com/xdb"
186 version="1.0"
187 elementFormDefault="qualified">
188
189 <simpleType name = "short_name">
190 <restriction base = "string">
191 <maxLength value="30"/>
192 </restriction>
193 </simpleType>
194
195 <simpleType name = "long_name">
196 <restriction base = "string">
197 <maxLength value="4000"/>
198 </restriction>
199 </simpleType>
200
201 <simpleType name = "db_name">
202 <restriction base = "string">
203 <maxLength value="128"/>
204 </restriction>
205 </simpleType>
206
207 <!-- Default session parameter is used if format is not specified -->
208 <complexType name="datetime_format">
209 <sequence>
210 <element name = "value" type = "string" nillable="true"/>
211 <element name = "format" type = "string" minOccurs="0" nillable="true"/>
212 </sequence>
213 </complexType>
214
215 <complexType name="anydata">
216 <choice>
217 <element name="varchar2" type = "string" xdb:SQLType="VARCHAR2"
218 nillable="true"/>
219
220 <!-- Represent char as varchar2. xdb:CHAR blank pads upto 2000 bytes! -->
221 <element name="char" type = "string" xdb:SQLType="VARCHAR2"
222 nillable="true"/>
223 <element name="nchar" type = "string" xdb:SQLType="NVARCHAR2"
224 nillable="true"/>
225
226 <element name="nvarchar2" type = "string" xdb:SQLType="NVARCHAR2"
227 nillable="true"/>
228 <element name="number" type = "double" xdb:SQLType="NUMBER"
229 nillable="true"/>
230 <element name="raw" type = "hexBinary" xdb:SQLType="RAW"
231 nillable="true"/>
232 <element name="date" type = "lcr:datetime_format"/>
233 <element name="timestamp" type = "lcr:datetime_format"/>
234 <element name="timestamp_tz" type = "lcr:datetime_format"/>
235 <element name="timestamp_ltz" type = "lcr:datetime_format"/>
236
237 <!-- Interval YM should be as per format allowed by SQL -->
238 <element name="interval_ym" type = "string" nillable="true"/>
239
240 <!-- Interval DS should be as per format allowed by SQL -->
241 <element name="interval_ds" type = "string" nillable="true"/>
242
243 </choice>
244 </complexType>
245
246 <complexType name="column_value">
247 <sequence>
248 <element name = "column_name" type = "lcr:long_name" nillable="false"/>
249 <element name = "data" type = "lcr:anydata" nillable="false"/>
250 <element name = "lob_information" type = "string" minOccurs="0"
251 nillable="true"/>
252 <element name = "lob_offset" type = "nonNegativeInteger" minOccurs="0"
253 nillable="true"/>
254 <element name = "lob_operation_size" type = "nonNegativeInteger"
255 minOccurs="0" nillable="true"/>
256 </sequence>
257 </complexType>
258
259 <element name = "ROW_LCR">
260 <complexType>
261 <sequence>
265 <element name = "object_owner" type = "lcr:short_name"
262 <element name = "source_database_name" type = "lcr:db_name"
263 nillable="false"/>
264 <element name = "command_type" type = "string" nillable="false"/>
266 nillable="false"/>
267 <element name = "object_name" type = "lcr:short_name"
268 nillable="false"/>
269 <element name = "tag" type = "hexBinary" xdb:SQLType="RAW"
270 minOccurs="0" nillable="true"/>
271 <element name = "transaction_id" type = "string" minOccurs="0"
272 nillable="true"/>
273 <element name = "scn" type = "double" xdb:SQLType="NUMBER"
274 minOccurs="0" nillable="true"/>
275 <element name = "old_values" minOccurs = "0">
276 <complexType>
277 <sequence>
278 <element name = "old_value" type="lcr:column_value"
279 maxOccurs = "unbounded"/>
280 </sequence>
281 </complexType>
282 </element>
283 <element name = "new_values" minOccurs = "0">
284 <complexType>
285 <sequence>
286 <element name = "new_value" type="lcr:column_value"
287 maxOccurs = "unbounded"/>
288 </sequence>
289 </complexType>
290 </element>
291 </sequence>
292 </complexType>
293 </element>
294
295 <element name = "DDL_LCR">
296 <complexType>
297 <sequence>
298 <element name = "source_database_name" type = "lcr:db_name"
299 nillable="false"/>
300 <element name = "command_type" type = "string" nillable="false"/>
301 <element name = "current_schema" type = "lcr:short_name"
302 nillable="false"/>
303 <element name = "ddl_text" type = "string" nillable="false"/>
304 <element name = "object_type" type = "string"
305 minOccurs = "0" nillable="true"/>
306 <element name = "object_owner" type = "lcr:short_name"
307 minOccurs = "0" nillable="true"/>
308 <element name = "object_name" type = "lcr:short_name"
309 minOccurs = "0" nillable="true"/>
310 <element name = "logon_user" type = "lcr:short_name"
311 minOccurs = "0" nillable="true"/>
312 <element name = "base_table_owner" type = "lcr:short_name"
313 minOccurs = "0" nillable="true"/>
314 <element name = "base_table_name" type = "lcr:short_name"
315 minOccurs = "0" nillable="true"/>
316 <element name = "tag" type = "hexBinary" xdb:SQLType="RAW"
317 minOccurs = "0" nillable="true"/>
318 <element name = "transaction_id" type = "string"
319 minOccurs = "0" nillable="true"/>
320 <element name = "scn" type = "double" xdb:SQLType="NUMBER"
321 minOccurs = "0" nillable="true"/>
322 </sequence>
323 </complexType>
324 </element>
325 </schema>';
326 end;