1 PACKAGE SDO_GEOR_ADMIN AUTHID CURRENT_USER AS
2
3 -- ---------------------------------------------------------------------
4 -- procedure to create DML triggers on a georaster table
5 -- ---------------------------------------------------------------------
6
7 PROCEDURE createDMLTrigger
8 (
9 tableName varchar2,
10 columnName varchar2
11 );
12
13
14 -- ---------------------------------------------------------------------
15 -- NAME
16 -- listRegisteredRDT
17 --
18 -- DESCRIPTION
19 -- This function lists all registereded RDT names in the table
20 -- mdsys.sdo_geor_sysdata_table
21 --
22 -- ARGUMENTS
23 -- None.
24 --
25 -- NOTES
26 -- This function should be run by any end user.
27 --
28 -- ---------------------------------------------------------------------
29 Function listRegisteredRDT return mdsys.sdo_string2_arrayset DETERMINISTIC PARALLEL_ENABLE;
30
31 -- ---------------------------------------------------------------------
32 -- NAME
33 -- isRDTNameUnique
34 --
35 -- DESCRIPTION
36 -- This function is used to check if the specific RDT name is unique
37 -- in the table mdsys.sdo_geor_sysdata_table
38 --
39 -- ARGUMENTS
40 -- rdtName.
41 --
42 -- NOTES
43 -- This function should be run by any end user.
44 --
45 -- ---------------------------------------------------------------------
46 Function isRDTNameUnique(rdtName VARCHAR2) return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
47
48 -- ---------------------------------------------------------------------
49 -- NAME
50 -- getUniqueRDTName
51 --
52 -- DESCRIPTION
53 -- This function returns an unique RDT name.
54 --
55 -- ARGUMENTS
56 -- None.
57 --
58 -- NOTES
59 -- This function should be run by any end user.
60 --
61 -- ---------------------------------------------------------------------
62 Function getUniqueRDTName return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
63
64
65 -- ---------------------------------------------------------------------
66 -- NAME
67 -- listGeoRasterTables
68 --
69 -- DESCRIPTION
70 -- For user mdsys: this function lists all GeoRaster tables defined in
71 -- the database.
72 -- output format is:
73 -- SCHEMA TABLE
74 -- For other users: this function lists all GeoRaster tables defined in
75 -- the current schema.
76 -- output format is:
77 -- TABLE
78 --
79 -- ARGUMENTS
80 -- None.
81 --
82 -- NOTES
83 -- This function should be run by any end user.
84 --
85 -- ---------------------------------------------------------------------
86 Function listGeoRasterTables return MDSYS.sdo_string2_arrayset DETERMINISTIC PARALLEL_ENABLE;
87
88 -- ---------------------------------------------------------------------
89 -- NAME
90 -- listGeoRasterColumns
91 --
92 -- DESCRIPTION
93 -- For user mdsys: this function lists all GeoRaster columns defined in
94 -- the database.
95 -- output format is:
96 -- SCHEMA TABLE COLUMN STATUS
97 -- Note: STATUS is used to indicate if a DML trigger is created on this
98 -- GeoRaster column or not.
99 -- For other users: this function lists all GeoRaster columnss defined in
100 -- the current schema.
101 -- output format is:
102 -- TABLE COLUMN STATUS
103 -- Note: STATUS is used to indicate if a DML trigger is created on this
104 -- GeoRaster column or not.
105 --
106 -- ARGUMENTS
107 -- None.
108 --
109 -- NOTES
110 -- This function should be run by any end user.
111 --
112 -- ---------------------------------------------------------------------
113 Function listGeoRasterColumns return MDSYS.sdo_string2_arrayset DETERMINISTIC PARALLEL_ENABLE;
114
115 -- ---------------------------------------------------------------------
116 -- NAME
117 -- registerGeoRasterColumns
118 --
119 -- DESCRIPTION
120 -- For user mdsys: this procedure creates dml triggers for all GeoRaster
121 -- columns defined in the database.
122 -- For other users:this procedure creates dml triggers for all GeoRaster
123 -- columns defined in current schema.
124 --
125 --
126 -- ARGUMENTS
127 -- None.
128 --
129 -- NOTES
130 -- This procedure should be run by any end user.
131 --
132 -- ---------------------------------------------------------------------
133 Procedure registerGeoRasterColumns;
134
135 -- ---------------------------------------------------------------------
136 -- NAME
137 -- listGeoRasterObjects
138 --
139 -- DESCRIPTION
140 -- For user mdsys: this function lists all GeoRaster objects defined in
141 -- the database.
142 -- output format is:
143 -- SCHEMA TABLE COLUMN RDT RID STATUS
144 -- Note: STATUS is used to indicate if this georaster object is
145 -- registered in the mdsys.sdo_geor_sysdata_table or not.
146 -- For other users: this function lists all GeoRaster objects defined in
147 -- the current schema.
148 -- output foramt is:
149 -- TABLE COLUMN RDT RID STATUS
150 -- Note: STATUS is used to indicate if this georaster object is
151 -- registered in the mdsys.sdo_geor_sysdata_table or not.
152 --
153 -- ARGUMENTS
154 -- None.
155 --
156 -- NOTES
157 -- This function should be run by any end user.
158 --
159 -- ---------------------------------------------------------------------
160 Function listGeoRasterObjects return MDSYS.sdo_string2_arrayset DETERMINISTIC PARALLEL_ENABLE;
161
162 -- ---------------------------------------------------------------------
163 -- NAME
164 -- registerGeoRasterObjects
165 --
166 -- DESCRIPTION
167 -- For user mdsys: this procedure registers all GeoRaster objects defined
168 -- in the database.
169 -- For other users:this procedure registers all GeoRaster objects defined
170 -- in current schema.
171 --
172 -- ARGUMENTS
173 -- None.
174 --
175 -- NOTES
176 -- This procedure should be run by any end user.
177 --
178 -- ---------------------------------------------------------------------
179 Procedure registerGeoRasterObjects;
180
181 -- ---------------------------------------------------------------------
182 -- NAME
183 -- listRDT
184 --
185 -- DESCRIPTION
186 -- For user mdsys: this function lists all RDT tables defined in
187 -- the database,which include registered and
188 -- unregistered RDTs in the mdsys.sdo_geor_sysdata_table.
189 -- output format is:
190 -- SCHEMA TABLE
191 -- For other users: this function lists all RDT tables defined in
192 -- the current schema,,which include registered and
193 -- unregistered RDTs in the mdsys.sdo_geor_sysdata_table.
194 -- output foramt is:
195 -- TABLE
196 --
197 -- ARGUMENTS
198 -- None.
199 --
200 -- NOTES
201 -- This function should be run by any end user.
202 --
203 -- ---------------------------------------------------------------------
204 Function listRDT return MDSYS.sdo_string2_arrayset DETERMINISTIC PARALLEL_ENABLE;
205
206 -- ---------------------------------------------------------------------
207 -- NAME
208 -- listUnregisteredRDT
209 --
210 -- DESCRIPTION
211 -- For user mdsys: this function lists all unregistered RDT tables
212 -- defined in the database.
213 -- output format is:
214 -- SCHEMA TABLE
215 -- For other users: this function lists all unregistered RDT tables
216 -- defined in the current schema.
217 -- output foramt is:
218 -- TABLE
219 --
220 -- ARGUMENTS
221 -- None.
222 --
223 -- NOTES
224 -- This function should be run by any end user.
225 --
226 -- ---------------------------------------------------------------------
227 Function listUnregisteredRDT return MDSYS.sdo_string2_arrayset DETERMINISTIC PARALLEL_ENABLE;
228
229 -- ---------------------------------------------------------------------
230 -- NAME
231 -- checkSysdataEntries
232 --
233 -- DESCRIPTION
234 -- For user mdsys: this function checks all sysdata entries in the
235 -- database, and prints out a report.
236 -- the following is a list of invalid cases
237 -- 1)RDT name isn't unique
238 -- 2)GeoRaster table doesn't exist
239 -- 3)GeoRaster column doesn't exist
240 -- 4)GeoRaster object doesn't exist
241 -- 5)Non-empty or Non-blank GeoRaster object, but
242 -- RDT doesn't exist
243 -- 6)Duplicate GeoRaster objects(RDT+RID non-unique)
244 --
245 -- For other users: this function checks all sysdata entries related to
246 -- the current schema, and prints out a report.
247 --
248 -- ARGUMENTS
249 -- None.
250 --
251 -- NOTES
252 -- This function should be run by any end user.
253 --
254 -- ---------------------------------------------------------------------
255 Function checkSysdataEntries return MDSYS.sdo_string2_array DETERMINISTIC PARALLEL_ENABLE;
256
257 -- ---------------------------------------------------------------------
258 -- NAME
259 -- maintainSysdataEntries
260 --
261 -- DESCRIPTION
262 -- For user mdsys: this function maintains all sysdata entries in the
263 -- database, and make them valid.
264 -- the following is a list of actions to invalid cases
265 -- 1)RDT name isn't unique : rename non-unique RDT
266 -- 2)GeoRaster table doesn't exist : remove entry
267 -- 3)GeoRaster column doesn't exist : remove entry
268 -- 4)GeoRaster object doesn't exist : remove entry
269 -- 5)Non-empty or Non-blank GeoRaster object, but
270 -- RDT doesn't exist : remove entry
271 -- 6)Duplicate GeoRaster objects(RDT+RID non-unique):remove entry .
272 --
273 -- For other users: this function maintains all sysdata entries related to
274 -- the current schema.
275 -- 1)RDT name isn't unique : no action
276 -- 2)GeoRaster table doesn't exist : remove entry
277 -- 3)GeoRaster column doesn't exist : remove entry
278 -- 4)GeoRaster object doesn't exist : remove entry
279 -- 5)Non-empty or Non-blank GeoRaster object, but
280 -- RDT doesn't exist : remove entry
281 -- 6)Duplicate GeoRaster objects(RDT+RID non-unique):remove entry .
282 --
283 -- ARGUMENTS
284 -- None.
285 --
286 -- NOTES
287 -- This function should be run by any end user.
288 --
289 -- ---------------------------------------------------------------------
290 Function maintainSysdataEntries return MDSYS.sdo_string2_array DETERMINISTIC PARALLEL_ENABLE;
291
292
293
294 -- ---------------------------------------------------------------------
295 -- NAME
296 -- isUpgradeNeeded
297 --
298 -- DESCRIPTION
299 -- For user mdsys: this function checks whole database,and prints
300 -- out a report about validation of whole GeoRaster
301 -- inforstrcture/data
302 -- the following is a list of invalid cases
303 -- 1)RDT name isn't unique
304 -- 2)GeoRaster table doesn't exist
305 -- 3)GeoRaster column doesn't exist
306 -- 4)Non-empty or Non-blank GeoRaster object, but
307 -- RDT doesn't exist
308 -- 5)Duplicate GeoRaster objects(RDT+RID non-unique)
309 -- 6)Non-registered GeoRaster columns
310 -- 7)Non-unique RDT(Non-registered) table
311 -- 8)Non-registered GeoRaster objects
312 -- 9)Non-registered RDT table
313 --
314 -- For other users: this function checks whole schema,and prints
315 -- out a report about validation of whole GeoRaster
316 -- inforstrcture/data
317 --
318 -- ARGUMENTS
319 -- None.
320 --
321 -- NOTES
322 -- This function should be run by any end user.
323 --
324 -- ---------------------------------------------------------------------
325 Function isUpgradeNeeded return MDSYS.sdo_string2_array DETERMINISTIC PARALLEL_ENABLE;
326
327
328 -- ---------------------------------------------------------------------
329 -- NAME
330 -- upgradeGeoRaster
331 --
332 -- DESCRIPTION
333 -- For user mdsys: this function maintains whole GeoRaster
334 -- infrastucture/data on the database level
335 --
336 -- For other users: this function maintains whole GeoRaster
337 -- infrastucture/data in schema level
338 --
339 -- ARGUMENTS
340 -- None.
341 --
342 -- NOTES
343 -- This function should be run by any end user.
344 --
345 -- ---------------------------------------------------------------------
346 Function upgradeGeoRaster return MDSYS.sdo_string2_array DETERMINISTIC PARALLEL_ENABLE;
347
348
349 -- ---------------------------------------------------------------------
350 -- NAME
351 -- listDanglingRasterData
352 --
353 -- DESCRIPTION
354 -- For user mdsys: this function lists all dangling data
355 -- on the database level
356 --
357 -- For other users: this function lists dangling data
358 -- in schema level
359 --
360 -- ARGUMENTS
361 -- None.
362 --
363 -- NOTES
364 -- This function should be run by any end user.
365 --
366 -- ---------------------------------------------------------------------
367 Function listDanglingRasterData return MDSYS.sdo_string2_arrayset DETERMINISTIC PARALLEL_ENABLE;
368
369
370
371 END SDO_GEOR_ADMIN;
[Home] [Help]