1 PACKAGE sdo_util AUTHID current_user AS
2
3 -- CONSTANT DECLARATION
4 SDO_GTYPE_CURVE CONSTANT NUMBER := 2;
5 SDO_GTYPE_POLYGON CONSTANT NUMBER := 3;
6 SDO_GTYPE_COLLECTION CONSTANT NUMBER := 4;
7 SDO_GTYPE_MULTICURVE CONSTANT NUMBER := 6;
8 SDO_GTYPE_MULTIPOLYGON CONSTANT NUMBER := 7;
9
10
11 Function expand_multi_point (geometry IN mdsys.sdo_geometry)
12 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
13
14 FUNCTION expand_geom (geometry IN mdsys.sdo_geometry)
15 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
16
17 FUNCTION extract(geometry IN mdsys.sdo_geometry,
18 element IN NUMBER,
19 ring IN NUMBER DEFAULT 0)
20 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
21 PRAGMA restrict_references(extract, wnds, rnps, wnps, trust);
22
23 FUNCTION extract_all(geometry IN mdsys.sdo_geometry,
24 flatten IN NUMBER DEFAULT 1)
25 RETURN mdsys.sdo_geometry_array DETERMINISTIC PARALLEL_ENABLE;
26 PRAGMA restrict_references(extract_all, wnds, rnps, wnps, trust);
27
28 FUNCTION append(geometry1 IN MDSYS.sdo_geometry,
29 geometry2 IN MDSYS.sdo_geometry)
30 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
31 PRAGMA restrict_references(append, wnds, wnps);
32
33 FUNCTION ExtractVoids(geometry IN mdsys.sdo_geometry,
34 dim IN mdsys.sdo_dim_array)
35 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
36 PRAGMA restrict_references(ExtractVoids, rnds, wnds, rnps, wnps, trust);
37
38 FUNCTION GetVertices(geometry IN mdsys.sdo_geometry)
39 RETURN vertex_set_type;
40 -- PRAGMA restrict_references(GetVertices, wnds, rnps, wnps);
41
42 FUNCTION GetNumElem(geometry IN mdsys.sdo_geometry)
43 RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE;
44 PRAGMA restrict_references(GetNumElem, rnds, wnds, rnps, wnps, trust);
45
46 FUNCTION GetNumRings(
47 geom IN MDSYS.SDO_GEOMETRY)
48 RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE;
49 PRAGMA restrict_references(GetNumRings, rnds, wnds, rnps, wnps, trust);
50
51 FUNCTION GetNumVertices(geometry IN mdsys.sdo_geometry)
52 RETURN NUMBER PARALLEL_ENABLE;
53 PRAGMA restrict_references(GetNumVertices, rnds, wnds, rnps, wnps, trust);
54
55 FUNCTION OuterLn(geometry IN mdsys.sdo_geometry,
56 dim IN mdsys.sdo_dim_array)
57 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
58 PRAGMA restrict_references(OuterLn,rnds,wnds,rnps,wnps,trust);
59
60 FUNCTION RefineMGon(mgon IN mdsys.sdo_geometry,
61 gon IN mdsys.sdo_geometry,
62 dim IN mdsys.sdo_dim_array)
63 RETURN mdsys.sdo_geometry;
64 PRAGMA restrict_references(RefineMGon,rnds,wnds,rnps,wnps,trust);
65
66 -- Determine whether or not a string contains a valid numeric value.
67 FUNCTION mdutl_is_numeric(instr varchar2,
68 format_mask varchar2)
69 RETURN number DETERMINISTIC PARALLEL_ENABLE;
70 PRAGMA restrict_references(mdutl_is_numeric, wnds, rnps, wnps, trust);
71
72 -- Safely convert "number" to corresponding "character" representation
73 -- For more information on this function, please refer to the PL/SQL
74 -- documentation for the TO_CHAR() function.
75 FUNCTION number_to_char(value IN NUMBER,
76 format_mask IN VARCHAR2 DEFAULT NULL,
77 nls_language IN VARCHAR2 DEFAULT NULL)
78 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
79 PRAGMA restrict_references(number_to_char, wnds, rnps, wnps, trust);
80
81 FUNCTION number_to_char(value IN VARCHAR2,
82 format_mask IN VARCHAR2 DEFAULT NULL,
83 nls_language IN VARCHAR2 DEFAULT NULL)
84 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
85 PRAGMA restrict_references(number_to_char, wnds, rnps, wnps, trust);
86
87 FUNCTION number_to_char(value IN DATE,
88 format_mask IN VARCHAR2 DEFAULT NULL,
89 option_setting IN VARCHAR2 DEFAULT NULL)
90 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
91 PRAGMA restrict_references(number_to_char, wnds, rnps, wnps, trust);
92
93 FUNCTION number_to_char(value IN TIMESTAMP,
94 format_mask IN VARCHAR2 DEFAULT NULL,
95 option_setting IN VARCHAR2 DEFAULT NULL)
96 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
97 PRAGMA restrict_references(number_to_char, wnds, rnps, wnps, trust);
98
99 FUNCTION number_to_char(value IN RAW)
100 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
101 PRAGMA restrict_references(number_to_char, wnds, rnps, wnps, trust);
102
103 FUNCTION number_to_char(value IN CLOB) -- NTEXT
104 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
105 PRAGMA restrict_references(number_to_char, wnds, rnps, wnps, trust);
106
107 -- truncate the original number up to no_of_digits
108 -- no_of_digits positive: truncate the number to no_of_digits AFTER the decimal point
109 -- ex: truncate_number(1.123456789,5) returns 1.12345
110 -- no_of_digits negative: truncate the number up to no_of_digits BEFORE the decimal point
111 -- ex: truncate_number(987654321.123456789,-5) returns 987600000.0
112
113 FUNCTION truncate_number(value NUMBER, no_of_digits NUMBER)
114 RETURN NUMBER PARALLEL_ENABLE;
115 PRAGMA restrict_references(truncate_number, wnds, rnps, wnps);
116
117 FUNCTION rectify_geometry(
118 geometry IN MDSYS.SDO_GEOMETRY,
119 tolerance IN NUMBER)
120 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
121 PRAGMA RESTRICT_REFERENCES(rectify_geometry, rnds, wnds, rnps, wnps, trust);
122
123 /* simplify a geometry */
124 FUNCTION simplify(
125 geometry IN mdsys.sdo_geometry,
126 threshold IN NUMBER,
127 tolerance IN NUMBER := 0.0000005,
128 remove_loops IN NUMBER := 0)
129 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
130 PRAGMA restrict_references(simplify, rnds, wnds, rnps, wnps, trust);
131
132 FUNCTION simplifyVW(
133 geometry IN mdsys.sdo_geometry,
134 vertex_threshold IN NUMBER,
135 tolerance IN NUMBER := 0.0000005,
136 remove_loops IN NUMBER := 0)
137 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
138 PRAGMA restrict_references(simplifyVW, rnds, wnds, rnps, wnps, trust);
139
140
141 FUNCTION polygontoline(geometry IN mdsys.sdo_geometry)
142 return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
143
144 FUNCTION point_to_line(
145 geom1 IN mdsys.sdo_geometry,
146 geom2 IN mdsys.sdo_geometry,
147 tol IN number := 10e-16)
148 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
149
150 FUNCTION remove_duplicates(geometry IN sdo_geometry, dim in sdo_dim_array)
151 return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
152
153 FUNCTION remove_duplicate_vertices(geometry IN sdo_geometry,
154 tolerance in NUMBER)
155 return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
156
157 FUNCTION circle_polygon (point MDSYS.SDO_GEOMETRY,
158 radius number,
159 arc_tolerance number,
160 start_azimuth number default NULL,
161 end_azimuth number default NULL,
162 orientation number default NULL,
163 arc number default NULL)
164 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
165
166 FUNCTION circle_polygon (center_longitude number,
167 center_latitude number,
168 radius number,
169 arc_tolerance number)
170 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
171
172 FUNCTION circle_polygon (center_longitude number,
173 center_latitude number,
174 radius number,
175 start_azimuth number,
176 end_azimuth number,
177 arc_tolerance number)
178 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
179
180 FUNCTION ellipse_polygon (center_longitude number,
181 center_latitude number,
182 semi_major_axis number,
183 semi_minor_axis number,
184 azimuth number,
185 arc_tolerance number)
186 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
187
188 FUNCTION point_at_bearing(start_point sdo_geometry,
189 bearing number,
190 distance number)
191 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
192
193 PROCEDURE bearing_tilt_for_points(
194 start_point sdo_geometry,
195 end_point sdo_geometry,
196 tol number,
197 bearing OUT number,
198 tilt OUT number) ;
199
200 FUNCTION convert_unit(value NUMBER, in_unit varchar2, out_unit varchar2)
201 RETURN number PARALLEL_ENABLE;
202
203 FUNCTION convert_distance(srid number, distance NUMBER, unit_spec varchar2)
204 RETURN number PARALLEL_ENABLE;
205
206 PROCEDURE Prepare_For_TTS (table_space IN VARCHAR2);
207
208 PROCEDURE Initialize_Indexes_For_TTS ;
209
210 FUNCTION to_clob(Geometry IN MDSYS.SDO_GEOMETRY)
211 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
212
213 FUNCTION from_clob(ClobGeom IN CLOB)
214 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
215
216 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY)
217 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
218
219 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,
220 srsNameSpace IN varchar2, srsNSAlias IN varchar2)
221 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
222
223 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,
224 coordOrder IN number)
225 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
226
227 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,
228 srsNameSpace IN varchar2, srsNSAlias IN varchar2,
229 coordOrder IN number)
230 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
231
232 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY)
233 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
234
235 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,
236 srsNameSpace IN varchar2, srsNSAlias IN varchar2)
237 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
238
239 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,
240 coordOrder IN number)
241 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
242
243 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,
244 srsNameSpace IN varchar2, srsNSAlias IN varchar2,
245 coordOrder IN number)
246 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
247
248 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY)
249 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
250
251 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,
252 srsNameSpace IN varchar2, srsNSAlias IN varchar2)
253 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
254
255 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,
256 coordOrder IN number)
257 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
258
259 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,
260 srsNameSpace IN varchar2, srsNSAlias IN varchar2,
261 coordOrder IN number)
262 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
263
264 FUNCTION to_kmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY)
265 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
266
267 FUNCTION to_wkbgeometry(geometry IN MDSYS.SDO_GEOMETRY)
268 RETURN BLOB DETERMINISTIC PARALLEL_ENABLE;
269
270 FUNCTION to_wktgeometry(geometry IN MDSYS.SDO_GEOMETRY)
271 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE;
272
273 FUNCTION to_wktgeometry_varchar(geometry IN MDSYS.SDO_GEOMETRY)
274 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
275
276 FUNCTION from_wkbgeometry(geometry IN BLOB)
277 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
278
279 FUNCTION from_wktgeometry(geometry IN CLOB)
280 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
281
282 FUNCTION from_wktgeometry(geometry IN VARCHAR2)
283 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
284
285 FUNCTION from_GMLgeometry(geometry IN CLOB)
286 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
287
288 FUNCTION from_GMLgeometry(geometry IN CLOB, srsNameSpace IN varchar2)
289 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
290
291 FUNCTION from_GMLgeometry(geometry IN VARCHAR2)
292 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
293
294 FUNCTION from_GMLgeometry(geometry IN VARCHAR2, srsNameSpace IN varchar2)
295 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
296
297 FUNCTION from_GMLgeometry(geometry IN CLOB,
298 coordOrder IN number)
299 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
300
301 FUNCTION from_GMLgeometry(geometry IN CLOB, srsNameSpace IN varchar2,
302 coordOrder IN number)
303 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
304
305 FUNCTION from_GMLgeometry(geometry IN VARCHAR2,
306 coordOrder IN number)
307 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
308
309 FUNCTION from_GMLgeometry(geometry IN VARCHAR2, srsNameSpace IN varchar2,
310 coordOrder IN number)
311 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
312
313 FUNCTION from_GML311geometry(geometry IN CLOB)
314 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
315
316 FUNCTION from_GML311geometry(geometry IN CLOB, srsNameSpace IN varchar2)
317 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
318
319 FUNCTION from_GML311geometry(geometry IN VARCHAR2)
320 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
321
322 FUNCTION from_GML311geometry(geometry IN VARCHAR2, srsNameSpace IN varchar2)
323 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
324
325 FUNCTION from_GML311geometry(geometry IN CLOB,
326 coordOrder IN number)
327 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
328
329 FUNCTION from_GML311geometry(geometry IN CLOB, srsNameSpace IN varchar2,
330 coordOrder IN number)
331 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
332
336
333 FUNCTION from_GML311geometry(geometry IN VARCHAR2,
334 coordOrder IN number)
335 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
337 FUNCTION from_GML311geometry(geometry IN VARCHAR2, srsNameSpace IN varchar2,
338 coordOrder IN number)
339 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
340
341 FUNCTION from_KMLgeometry(geometry IN CLOB)
342 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
343
344 FUNCTION from_KMLgeometry(geometry IN VARCHAR2)
345 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
346
347 FUNCTION extrude(geometry IN MDSYS.SDO_GEOMETRY,
348 grdHeight IN SDO_NUMBER_ARRAY,
349 height IN SDO_NUMBER_ARRAY,
350 cond IN VARCHAR2,
351 tol IN NUMBER)
352 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
353
354 FUNCTION extrude(geometry IN MDSYS.SDO_GEOMETRY,
355 grdHeight IN SDO_NUMBER_ARRAY,
356 height IN SDO_NUMBER_ARRAY,
357 tol IN NUMBER,
358 optional3dSrid IN NUMBER DEFAULT NULL)
359 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
360
361
362 FUNCTION affinetransforms(geometry IN MDSYS.SDO_GEOMETRY,
363 translation IN VARCHAR2 DEFAULT 'FALSE', tx IN NUMBER DEFAULT 0.0, ty IN NUMBER DEFAULT 0.0, tz IN NUMBER DEFAULT 0.0,
364 scaling IN VARCHAR2 DEFAULT 'FALSE', Psc1 IN MDSYS.SDO_GEOMETRY DEFAULT NULL, sx IN NUMBER DEFAULT 0.0, sy IN NUMBER DEFAULT 0.0, sz IN NUMBER DEFAULT 0.0,
365 rotation IN VARCHAR2 DEFAULT 'FALSE', P1 IN MDSYS.SDO_GEOMETRY DEFAULT NULL, line1 IN MDSYS.SDO_GEOMETRY DEFAULT NULL, angle IN NUMBER DEFAULT 0.0, dir IN NUMBER DEFAULT -1,
366 shearing IN VARCHAR2 DEFAULT 'FALSE', SHxy IN NUMBER DEFAULT 0.0, SHyx IN NUMBER DEFAULT 0.0, SHxz IN NUMBER DEFAULT 0.0, SHzx IN NUMBER DEFAULT 0.0, SHyz IN NUMBER DEFAULT 0.0, SHzy IN NUMBER DEFAULT 0.0,
367 reflection IN VARCHAR2 DEFAULT 'FALSE', Pref IN MDSYS.SDO_GEOMETRY DEFAULT NULL, lineR IN MDSYS.SDO_GEOMETRY DEFAULT NULL, dirR IN NUMBER DEFAULT -1, planeR IN VARCHAR2 DEFAULT 'FALSE', n IN SDO_NUMBER_ARRAY DEFAULT NULL, bigD IN SDO_NUMBER_ARRAY DEFAULT NULL)
368 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
369
370 FUNCTION extract3d(geometry IN MDSYS.SDO_GEOMETRY, label IN VARCHAR2)
371 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
372
373 FUNCTION getlabelbyelement(sourceGeometry IN MDSYS.SDO_GEOMETRY, queryElement IN MDSYS.SDO_GEOMETRY, tol IN NUMBER)
374 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
375
376 FUNCTION validate_wkbgeometry(geometry IN BLOB)
377 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
378
379 FUNCTION validate_wktgeometry(geometry IN CLOB)
380 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
381
382 FUNCTION validate_wktgeometry(geometry IN VARCHAR2)
383 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
384
385 FUNCTION concat_lines (geometry1 IN MDSYS.SDO_GEOMETRY,
386 geometry2 IN MDSYS.SDO_GEOMETRY)
387 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
388
389 PROCEDURE internal_ordinate_copy(src IN MDSYS.SDO_ORDINATE_ARRAY,
390 src_position IN INTEGER,
391 dst IN OUT NOCOPY MDSYS.SDO_ORDINATE_ARRAY,
392 dst_position IN INTEGER,
393 length IN INTEGER);
394
395 FUNCTION reverse_linestring(geometry IN MDSYS.SDO_GEOMETRY)
396 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
397
398 FUNCTION internal_merge_linestrings(geometry IN MDSYS.SDO_GEOMETRY)
399 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC;
400
401 FUNCTION internal_merge_linestrings(geomArr IN MDSYS.SDO_GEOMETRY_ARRAY)
402 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC;
403
404 FUNCTION internal_make_line_out_of_elem(
405 multilinestring IN MDSYS.SDO_GEOMETRY, element_index IN INTEGER)
406 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
407
408 PROCEDURE internal_reverse_line_points(
409 ordinates IN OUT NOCOPY MDSYS.SDO_ORDINATE_ARRAY);
410
411 ------------------------------------------------------------------
412 -- Name
413 -- Partition_Table
414 -- Purpose
415 -- Partitions the input "schema.tablename" into buckets of at
416 -- most ptn_capacity each. The partitioning is based on the
417 -- spatial extent or MBR stored as the intervals <min_di, max_di>
418 -- in each dimension di. The data is written back with
419 -- the ptn_id into the "output_table" which is assumed to be
420 -- be pre-created by the user.
421 -- The input <tablename> table is expected to have the following columns:
422 -- "rid" -- unique id for each row (e.g., the table rowid)
423 -- min_d1, max_d1 -- minimum and maximum values in dimension 1
424 -- min_d2, max_d2 -- minimum and maximum values in dimension 2
425 -- ..
426 -- min_dn, max_dn -- minimum and maximum values in dimension n
427 -- where n is the dimensionality specified by inp arg "numdim"
428 -- The input "wrk_tblspc" specifies the tablespace where "scratch-pad"
429 -- tables are created and dropped. Keep this tablespace different from
430 -- the tablespace in which the input <tablename> and output_table are.
431 -- (typical usage: create wrk_tblspc and drop after this procedure)
432 -- The arg "output_table" specifies where to write the output partitions
436 -- min_d2, max_d2, ...., min_dn, max_dn (all number columns).
433 -- This routine assumes the output_table is pre-created and has the
434 -- following columns:
435 -- ptn_id number, rid varchar2(24), min_d1 number, max_d1 number,
437 -- This routine writes the rows from <tablename> back to <output_table>
438 -- with the ptn_id set.
439 -- The arg <output_ptn_table> specifies where to write ptn extent information
440 -- This table should have the following numeric columns:
441 -- ptn_id, min_d1, max_d1, min_d2, max_d2, ...., min_dn, max_dn.
442 -- Parameter "numdim" specifies the number of dimensions.
443 -- Parameter "commit_interval" "n" specifies that commits happen
444 -- after every batch of n rows that are written to the <output_table>.
445 -- Parameter "packed_ptns" tries to pack the partitions.
446
447
448 PROCEDURE partition_table(schemaname in varchar2, tablename in varchar2,
449 output_data_table in varchar2,
450 output_ptn_table in varchar2,
451 ptn_capacity in number default 100,
452 numdim in number default 2,
453 wrk_tblspc in varchar2 default null,
454 ptn_type in varchar2 default null,
455 dop in number default 1);
456
457
458 ------------------------------------------------------------------
459 -- Name
460 -- DROP_WORK_TABLES
461 -- Purpose
462 -- This function drops any work tables and views in the current schema
463 -- created as part of partition_table, index creation, or
464 -- TIN/Point Cloud utilities.
465 --
466 -- DROPS all tables/views that match 'M%_<oidstr>$$%'
467 -- Input oidstr has to contain only hexadecimal numbers w/o spaces
468
469 PROCEDURE DROP_WORK_TABLES(oidstr varchar2);
470
471 FUNCTION remove_inner_rings(inpgeom SDO_GEOMETRY, inptol number)
472 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
473
474 FUNCTION quad_tiles(geom SDO_GEOMETRY, sdo_level number, tol number:=0.0000000005)
475 RETURN mdsys.F81_index_obj_array DETERMINISTIC;
476
477 /* This function generates hybrid tiles for a given Geometry.
478 Only 2D Geometry is supported.
479 The SDO_META values are appended to the SDO_CODE to make it easier
480 for use with other HHCODE functions. */
481 FUNCTION hybrid_tiles(geom SDO_GEOMETRY, sdo_level number := 4,
482 sdo_ntiles number := 100, tol number:=0.0000000005)
483 RETURN mdsys.H81_index_obj_array DETERMINISTIC;
484
485 FUNCTION interior_point (geom SDO_GEOMETRY, tol number := 0.00000000005)
486 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
487
488 FUNCTION number_of_components(geometry SDO_GEOMETRY, requested_type varchar2)
489 RETURN NUMBER PARALLEL_ENABLE;
490
491 FUNCTION get_2d_footprint(geometry SDO_GEOMETRY, tolerance number := 0.05)
492 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
493
494 FUNCTION convert3007to3008(geometry sdo_geometry)
495 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
496
497 FUNCTION get_boundary(geometry in sdo_geometry)
498 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
499 -------------------------------------------------------------------------
500
501 function validate_3dtheme(
502 theme_name varchar2)
503 return varchar2;
504
505 function validate_scene(
506 scene_name varchar2)
507 return varchar2;
508
509 function validate_viewframe(
510 viewframe_name varchar2)
511 return varchar2;
512
513 function theme3d_has_lod(
514 theme_name varchar2)
515 return number;
516
517 function theme3d_has_texture(
518 theme_name varchar2)
519 return number;
520
521 function theme3d_get_block_table(
522 theme_name varchar2)
523 return varchar2;
524
525 FUNCTION ToGnomonic(geom in sdo_geometry, longitude in number,
526 latitude in number)
527 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
528
529 FUNCTION getNurbsApprox(geometry IN mdsys.sdo_geometry,
530 tolerance IN number)
531 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
532 PRAGMA restrict_references(getNurbsApprox, rnds, wnds, rnps, wnps, trust);
533
534 FUNCTION jsph_getnurbsapprox(geometry IN mdsys.sdo_geometry)
535 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
536 PRAGMA restrict_references(jsph_getnurbsapprox, rnds, wnds, rnps, wnps, trust);
537
538 FUNCTION linear_key(geometry IN mdsys.sdo_geometry,
539 diminfo mdsys.sdo_dim_array,
540 lvl IN NUMBER := 8)
541 RETURN RAW DETERMINISTIC PARALLEL_ENABLE;
542
543 FUNCTION linear_key(geometry IN mdsys.sdo_geometry,
544 min_x IN NUMBER, min_y IN NUMBER,
545 max_x IN NUMBER, max_y IN NUMBER,
546 lvl IN NUMBER := 8)
547 RETURN RAW DETERMINISTIC PARALLEL_ENABLE;
548
549 procedure insert_sdo_geom_metadata(owner IN VARCHAR2,
550 table_name IN VARCHAR2,
551 column_name IN VARCHAR2,
552 diminfo IN mdsys.sdo_dim_array,
553 srid IN number);
554
555 END sdo_util;