1 PACKAGE SDO_JAVA_STP AUTHID current_user AS
2
3 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY)
4 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
5 'oracle.spatial.util.GML2.to_GMLGeometryCLOBJS(java.sql.Struct) return oracle.jdbc.OracleClob' ;
6
7 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,
8 srsNameSpace IN varchar2, srsNSAlias IN varchar2)
9 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
10 'oracle.spatial.util.GML2.to_GMLGeometryCLOBJS(java.sql.Struct, java.lang.String, java.lang.String) return oracle.jdbc.OracleClob' ;
11
12 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,
13 coordOrder number)
14 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
15 'oracle.spatial.util.GML2.to_GMLGeometryCLOBJS(java.sql.Struct, oracle.sql.NUMBER) return oracle.jdbc.OracleClob' ;
16
17 FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,
18 srsNameSpace IN varchar2, srsNSAlias IN varchar2,
19 coordOrder number)
20 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
21 'oracle.spatial.util.GML2.to_GMLGeometryCLOBJS(java.sql.Struct, java.lang.String, java.lang.String, oracle.sql.NUMBER) return oracle.jdbc.OracleClob' ;
22
23 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY)
24 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
25 'oracle.spatial.util.GML3.to_GML3GeometryCLOBJS(java.sql.Struct) return oracle.jdbc.OracleClob' ;
26
27 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,
28 srsNameSpace IN varchar2, srsNSAlias IN varchar2)
29 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
30 'oracle.spatial.util.GML3.to_GML3GeometryCLOBJS(java.sql.Struct, java.lang.String, java.lang.String) return oracle.jdbc.OracleClob' ;
31
32 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,
33 coordOrder number)
34 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
35 'oracle.spatial.util.GML3.to_GML3GeometryCLOBJS(java.sql.Struct, oracle.sql.NUMBER) return oracle.jdbc.OracleClob' ;
36
37 FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,
38 srsNameSpace IN varchar2, srsNSAlias IN varchar2,
39 coordOrder number)
40 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
41 'oracle.spatial.util.GML3.to_GML3GeometryCLOBJS(java.sql.Struct, java.lang.String, java.lang.String, oracle.sql.NUMBER) return oracle.jdbc.OracleClob' ;
42
43 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY)
44 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
45 'oracle.spatial.util.GML3.to_GML3_2GeometryCLOBJS(java.sql.Struct) return oracle.jdbc.OracleClob' ;
46
47 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,
48 srsNameSpace IN varchar2, srsNSAlias IN varchar2)
49 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
50 'oracle.spatial.util.GML3.to_GML3_2GeometryCLOBJS(java.sql.Struct, java.lang.String, java.lang.String) return oracle.jdbc.OracleClob' ;
51
52 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,
53 coordOrder number)
54 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
55 'oracle.spatial.util.GML3.to_GML3_2GeometryCLOBJS(java.sql.Struct, oracle.sql.NUMBER) return oracle.jdbc.OracleClob' ;
56
57 FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,
58 srsNameSpace IN varchar2, srsNSAlias IN varchar2,
59 coordOrder number)
60 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
61 'oracle.spatial.util.GML3.to_GML3_2GeometryCLOBJS(java.sql.Struct, java.lang.String, java.lang.String, oracle.sql.NUMBER) return oracle.jdbc.OracleClob' ;
62
63 FUNCTION to_kmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY)
64 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE AS LANGUAGE JAVA NAME
65 'oracle.spatial.util.KML2.to_KMLGeometryCLOBJS(java.sql.Struct) return oracle.jdbc.OracleClob' ;
66
67
68 FUNCTION from_wkbgeometry(geometry IN BLOB)
69 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
70 AS LANGUAGE JAVA NAME
71 'oracle.spatial.util.Adapters.wkbToSTRUCT(oracle.jdbc.OracleBlob) return java.sql.Struct';
72
73 FUNCTION from_wktgeometry(geometry IN CLOB)
74 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
75 AS LANGUAGE JAVA NAME
76 'oracle.spatial.util.Adapters.wktToSTRUCT(oracle.jdbc.OracleClob) return java.sql.Struct';
77
78
79 FUNCTION from_wktgeometry(geometry IN VARCHAR2)
80 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
81 AS LANGUAGE JAVA NAME
82 'oracle.spatial.util.Adapters.wktToSTRUCT(java.lang.String) return java.sql.Struct';
83
84
85 FUNCTION from_GMLgeometry(geometry IN CLOB)
86 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
87 AS LANGUAGE JAVA NAME
88 'oracle.spatial.util.Adapters.gmlToSTRUCT(oracle.jdbc.OracleClob) return java.sql.Struct';
89
90 FUNCTION from_GMLgeometry(geometry IN CLOB, srsNameSpace IN varchar2)
91 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
92 AS LANGUAGE JAVA NAME
93 'oracle.spatial.util.Adapters.gmlToSTRUCT(oracle.jdbc.OracleClob, java.lang.String) return java.sql.Struct';
94
95 FUNCTION from_GMLgeometry(geometry IN VARCHAR2)
96 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
97 AS LANGUAGE JAVA NAME
98 'oracle.spatial.util.Adapters.gmlToSTRUCT(java.lang.String) return java.sql.Struct';
99
100 FUNCTION from_GMLgeometry(geometry IN VARCHAR2, srsNameSpace IN varchar2)
101 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
102 AS LANGUAGE JAVA NAME
103 'oracle.spatial.util.Adapters.gmlToSTRUCT(java.lang.String, java.lang.String) return java.sql.Struct';
104
105 FUNCTION from_GMLgeometry(geometry IN CLOB,
106 coordOrder IN number)
107 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
108 AS LANGUAGE JAVA NAME
109 'oracle.spatial.util.Adapters.gmlToSTRUCT(oracle.jdbc.OracleClob, oracle.sql.NUMBER) return java.sql.Struct';
110
111 FUNCTION from_GMLgeometry(geometry IN CLOB, srsNameSpace IN varchar2,
112 coordOrder IN number)
113 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
114 AS LANGUAGE JAVA NAME
115 'oracle.spatial.util.Adapters.gmlToSTRUCT(oracle.jdbc.OracleClob, java.lang.String, oracle.sql.NUMBER) return java.sql.Struct';
116
117 FUNCTION from_GMLgeometry(geometry IN VARCHAR2,
118 coordOrder IN number)
119 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
120 AS LANGUAGE JAVA NAME
121 'oracle.spatial.util.Adapters.gmlToSTRUCT(java.lang.String, oracle.sql.NUMBER) return java.sql.Struct';
122
123 FUNCTION from_GMLgeometry(geometry IN VARCHAR2, srsNameSpace IN varchar2,
124 coordOrder IN number)
125 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
126 AS LANGUAGE JAVA NAME
127 'oracle.spatial.util.Adapters.gmlToSTRUCT(java.lang.String, java.lang.String, oracle.sql.NUMBER) return java.sql.Struct';
128
129 FUNCTION from_GML311geometry(geometry IN CLOB)
130 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
131 AS LANGUAGE JAVA NAME
132 'oracle.spatial.util.Adapters.gml311ToSTRUCT(oracle.jdbc.OracleClob) return java.sql.Struct';
133
134 FUNCTION from_GML311geometry(geometry IN CLOB, srsNameSpace IN varchar2)
135 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
136 AS LANGUAGE JAVA NAME
137 'oracle.spatial.util.Adapters.gml311ToSTRUCT(oracle.jdbc.OracleClob, java.lang.String) return java.sql.Struct';
138
139 FUNCTION from_GML311geometry(geometry IN VARCHAR2)
140 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
141 AS LANGUAGE JAVA NAME
142 'oracle.spatial.util.Adapters.gml311ToSTRUCT(java.lang.String) return java.sql.Struct';
143
144 FUNCTION from_GML311geometry(geometry IN VARCHAR2, srsNameSpace IN varchar2)
145 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
146 AS LANGUAGE JAVA NAME
147 'oracle.spatial.util.Adapters.gml311ToSTRUCT(java.lang.String, java.lang.String) return java.sql.Struct';
148
149 FUNCTION from_GML311geometry(geometry IN CLOB,
150 coordOrder IN number)
151 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
152 AS LANGUAGE JAVA NAME
153 'oracle.spatial.util.Adapters.gml311ToSTRUCT(oracle.jdbc.OracleClob, oracle.sql.NUMBER) return java.sql.Struct';
154
155 FUNCTION from_GML311geometry(geometry IN CLOB, srsNameSpace IN varchar2,
156 coordOrder IN number)
157 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
158 AS LANGUAGE JAVA NAME
159 'oracle.spatial.util.Adapters.gml311ToSTRUCT(oracle.jdbc.OracleClob, java.lang.String, oracle.sql.NUMBER) return java.sql.Struct';
160
161 FUNCTION from_GML311geometry(geometry IN VARCHAR2,
162 coordOrder IN number)
163 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
164 AS LANGUAGE JAVA NAME
165 'oracle.spatial.util.Adapters.gml311ToSTRUCT(java.lang.String, oracle.sql.NUMBER) return java.sql.Struct';
166
167 FUNCTION from_GML311geometry(geometry IN VARCHAR2, srsNameSpace IN varchar2,
168 coordOrder IN number)
169 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
170 AS LANGUAGE JAVA NAME
171 'oracle.spatial.util.Adapters.gml311ToSTRUCT(java.lang.String, java.lang.String, oracle.sql.NUMBER) return java.sql.Struct';
172
173 FUNCTION from_KMLgeometry(geometry IN CLOB)
174 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
175 AS LANGUAGE JAVA NAME
176 'oracle.spatial.util.Adapters.kmlToSTRUCT(oracle.jdbc.OracleClob) return java.sql.Struct';
177
178
179 FUNCTION from_KMLgeometry(geometry IN VARCHAR2)
180 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
181 AS LANGUAGE JAVA NAME
182 'oracle.spatial.util.Adapters.kmlToSTRUCT(java.lang.String) return java.sql.Struct';
183
184
185 FUNCTION affinetransforms(geometry IN MDSYS.SDO_GEOMETRY,
186 translation IN VARCHAR2, tx IN NUMBER, ty IN NUMBER, tz IN NUMBER,
187 scaling IN VARCHAR2, Psc1 IN MDSYS.SDO_GEOMETRY, sx IN NUMBER, sy IN NUMBER, sz IN NUMBER,
188 rotation IN VARCHAR2, P1 IN MDSYS.SDO_GEOMETRY, line1 IN MDSYS.SDO_GEOMETRY, angle IN NUMBER, dir IN NUMBER,
189 shearing IN VARCHAR2, SHxy IN NUMBER, SHyx IN NUMBER, SHxz IN NUMBER, SHzx IN NUMBER, SHyz IN NUMBER, SHzy IN NUMBER,
190 reflection IN VARCHAR2, Pref IN MDSYS.SDO_GEOMETRY, lineR IN MDSYS.SDO_GEOMETRY, dirR IN NUMBER, planeR IN VARCHAR2, n IN SDO_NUMBER_ARRAY, bigD IN SDO_NUMBER_ARRAY)
191 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
192 AS LANGUAGE JAVA NAME
193 'oracle.spatial.util.Adapters.affineTransforms(java.sql.Struct, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
194 java.lang.String, java.sql.Struct, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
195 java.lang.String, java.sql.Struct, java.sql.Struct, oracle.sql.NUMBER, oracle.sql.NUMBER,
196 java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
197 java.lang.String, java.sql.Struct, java.sql.Struct, oracle.sql.NUMBER, java.lang.String, oracle.spatial.type.SdoNumberArray, oracle.spatial.type.SdoNumberArray) return java.sql.Struct';
198
199
200 FUNCTION extract3d(geometry IN MDSYS.SDO_GEOMETRY, label IN VARCHAR2)
201 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
202 AS LANGUAGE JAVA NAME
203 'oracle.spatial.util.Adapters.extract3d(java.sql.Struct, java.lang.String) return java.sql.Struct';
204
205 FUNCTION getlabelbyelement(sourceGeometry IN MDSYS.SDO_GEOMETRY, queryElement IN MDSYS.SDO_GEOMETRY, tol IN NUMBER)
206 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE
207 AS LANGUAGE JAVA NAME
208 'oracle.spatial.util.Adapters.getlabelbyelement(java.sql.Struct, java.sql.Struct, oracle.sql.NUMBER) return java.lang.String';
209
213 'oracle.spatial.util.Adapters.validateWkb(oracle.jdbc.OracleBlob) return java.lang.String';
210 FUNCTION validate_wkbgeometry(geometry IN BLOB)
211 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE
212 AS LANGUAGE JAVA NAME
214
215 FUNCTION validate_wktgeometry(geometry IN CLOB)
216 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE
217 AS LANGUAGE JAVA NAME
218 'oracle.spatial.util.Adapters.validateWkt(oracle.jdbc.OracleClob) return java.lang.String';
219
220 FUNCTION validate_wktgeometry(geometry IN VARCHAR2)
221 RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE
222 AS LANGUAGE JAVA NAME
223 'oracle.spatial.util.Adapters.validateWkt(java.lang.String) return java.lang.String';
224
225
226 -- these functions are from sdo_3gl package
227 FUNCTION generate_buffer(geomobj IN mdsys.sdo_geometry,
228 dist IN NUMBER,
229 sma IN NUMBER, iflat IN NUMBER,
230 arcT IN NUMBER)
231 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
232 AS LANGUAGE JAVA NAME
233 'oracle.spatial.util.Adapters.buffer(java.sql.Struct, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return java.sql.Struct ';
234
235 FUNCTION anyInteract3D(Geometry1 IN MDSYS.SDO_GEOMETRY,
236 Geometry2 IN MDSYS.SDO_GEOMETRY,
237 is_g3d IN VARCHAR2,
238 tolerance IN number)
239 RETURN VARCHAR2 DETERMINISTIC
240 AS LANGUAGE JAVA NAME
241 'oracle.spatial.util.Adapters.anyInteract(java.sql.Struct, java.sql.Struct, java.lang.String, oracle.sql.NUMBER) return java.lang.String';
242
243 FUNCTION distance3D(Geometry1 IN MDSYS.SDO_GEOMETRY,
244 Geometry2 IN MDSYS.SDO_GEOMETRY,
245 is_g3d IN VARCHAR2,
246 smajax IN NUMBER,
247 flattening IN NUMBER,
248 g3d_geog_crs_uom_factor IN NUMBER,
249 tolerance IN number)
250 RETURN number DETERMINISTIC
251 AS LANGUAGE JAVA NAME
252 'oracle.spatial.util.Adapters.distance(java.sql.Struct, java.sql.Struct, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return oracle.sql.NUMBER';
253
254 FUNCTION length3D(Geometry IN MDSYS.SDO_GEOMETRY,
255 count_shared_edges IN NUMBER,
256 is_g3d IN VARCHAR2,
257 smajax IN NUMBER,
258 flattening IN NUMBER,
259 g3d_geog_crs_uom_factor IN NUMBER,
260 tolerance IN number)
261 RETURN number DETERMINISTIC
262 AS LANGUAGE JAVA NAME
263 'oracle.spatial.util.Adapters.length(java.sql.Struct, oracle.sql.NUMBER, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return oracle.sql.NUMBER';
264
265 FUNCTION area3D(Geometry IN MDSYS.SDO_GEOMETRY,
266 is_g3d IN VARCHAR2,
267 smajax IN NUMBER,
268 flattening IN NUMBER,
269 g3d_geog_crs_uom_factor IN NUMBER,
270 tolerance IN number)
271 RETURN number DETERMINISTIC
272 AS LANGUAGE JAVA NAME
273 'oracle.spatial.util.Adapters.area(java.sql.Struct, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return oracle.sql.NUMBER';
274
275 FUNCTION volume3D(Geometry IN MDSYS.SDO_GEOMETRY,
276 is_g3d IN VARCHAR2,
277 smajax IN NUMBER,
278 flattening IN NUMBER,
279 g3d_geog_crs_uom_factor IN NUMBER,
280 tolerance IN number)
281 RETURN number DETERMINISTIC
282 AS LANGUAGE JAVA NAME
283 'oracle.spatial.util.Adapters.volume(java.sql.Struct, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return oracle.sql.NUMBER';
284
285
286 FUNCTION validateGeom3D(Geometry IN MDSYS.SDO_GEOMETRY,
287 conditional IN VARCHAR2,
288 chck3dsrid IN NUMBER,
289 tolerance IN number)
290 RETURN VARCHAR2 DETERMINISTIC
291 AS LANGUAGE JAVA NAME
292 'oracle.spatial.util.Adapters.validateGeom(java.sql.Struct, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER) return java.lang.String';
293
294 FUNCTION validate_layer_with_context3D(geom_table IN VARCHAR2,
295 geom_column IN VARCHAR2,
296 result_table IN VARCHAR2,
297 commit_interval IN NUMBER,
298 conditional IN VARCHAR2,
299 chck3dsrid IN NUMBER,
300 tolerance IN NUMBER)
301 RETURN NUMBER DETERMINISTIC
302 AS LANGUAGE JAVA NAME
303 'oracle.spatial.util.Adapters.validate_layer_with_context_3D(java.lang.String, java.lang.String, java.lang.String, oracle.sql.NUMBER, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER) return java.sql.NUMBER';
304
305 FUNCTION closestPoints3D(Geometry1 IN MDSYS.SDO_GEOMETRY,
306 Geometry2 IN MDSYS.SDO_GEOMETRY,
307 is_g3d IN VARCHAR2,
308 smajax IN NUMBER,
309 flattening IN NUMBER,
310 g3d_geog_crs_uom_factor IN NUMBER,
311 tolerance IN number)
312 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
313 AS LANGUAGE JAVA NAME
314 'oracle.spatial.util.Adapters.closestPoints(java.sql.Struct, java.sql.Struct, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return java.sql.Struct';
315
316 FUNCTION centroid3D(Geometry IN MDSYS.SDO_GEOMETRY,
317 tolerance IN number)
318 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
319 AS LANGUAGE JAVA NAME
323 FUNCTION ring_union_approx(geom SDO_GEOMETRY, tol number)
320 'oracle.spatial.util.Adapters.centroid_3d(java.sql.Struct, oracle.sql.NUMBER) return java.sql.Struct';
321
322 -- Removes innner rings of geom and returns collection
324 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
325 AS LANGUAGE JAVA NAME
326 'oracle.spatial.util.Adapters.ringUnionApprox(java.sql.Struct, oracle.sql.NUMBER) return java.sql.Struct';
327
328 FUNCTION inside3D(Geometry1 IN MDSYS.SDO_GEOMETRY,
329 Geometry2 IN MDSYS.SDO_GEOMETRY,
330 is_g3d IN VARCHAR2,
331 tolerance IN number)
332 RETURN VARCHAR2 DETERMINISTIC
333 AS LANGUAGE JAVA NAME
334 'oracle.spatial.util.Adapters.inside3d(java.sql.Struct, java.sql.Struct, java.lang.String, oracle.sql.NUMBER) return java.lang.String';
335
336 FUNCTION pctrclip(qry IN sdo_geometry,
337 other_qry IN mdsys.sdo_mbr,
338 pts IN BLOB, npts IN number, totdim IN number,
339 trs IN BLOB, ntrs IN number,
340 tol IN number,
341 include_custom_dim IN NUMBER) RETURN BLOB
342 AS LANGUAGE JAVA NAME
343 'oracle.spatial.util.Adapters.pctrclipJS(java.sql.Struct, java.sql.Struct, oracle.jdbc.OracleBlob, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.jdbc.OracleBlob, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return oracle.jdbc.OracleBlob';
344
345 function expandG3DGeoms(geom IN mdsys.sdo_geometry)
346 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
347 AS LANGUAGE JAVA NAME
348 'oracle.spatial.util.Adapters.expandG3Dgeoms(java.sql.Struct) return java.sql.Struct';
349
350
351 FUNCTION internal_simplifyvw(geometry IN MDSYS.SDO_GEOMETRY,
352 vertex_threshold IN NUMBER,
353 sma number,
354 iflat number)
355 return MDSYS.SDO_GEOMETRY deterministic PARALLEL_ENABLE
356 AS LANGUAGE JAVA NAME
357 'oracle.spatial.util.Adapters.simplifyVW(java.sql.Struct, oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER) return java.sql.Struct';
358
359 -- Java API for NURBS curve approximation
360 FUNCTION internal_getnurbsapprox(geometry IN MDSYS.SDO_GEOMETRY)
361 RETURN MDSYS.SDO_GEOMETRY deterministic PARALLEL_ENABLE
362 AS LANGUAGE JAVA NAME
363 'oracle.spatial.util.Adapters.getNurbsApprox(java.sql.Struct) return java.sql.Struct';
364
365 FUNCTION intl_to_wkbgeometry(geometry IN MDSYS.SDO_GEOMETRY)
366 RETURN BLOB DETERMINISTIC
367 AS LANGUAGE JAVA NAME
368 'oracle.spatial.util.Adapters.structToWkbJS(java.sql.Struct) return oracle.jdbc.OracleBlob';
369
370 FUNCTION intl_to_wktgeometry(geometry IN MDSYS.SDO_GEOMETRY)
371 RETURN CLOB DETERMINISTIC
372 AS LANGUAGE JAVA NAME
373 'oracle.spatial.util.Adapters.structToWktJS(java.sql.Struct) return oracle.jdbc.OracleClob';
374
375 FUNCTION intl_to_wktgeometry_varchar(geometry IN MDSYS.SDO_GEOMETRY)
376 RETURN VARCHAR2 DETERMINISTIC
377 AS LANGUAGE JAVA NAME
378 'oracle.spatial.util.Adapters.structToWktString(java.sql.Struct) return String';
379
380
381 FUNCTION intl_extrude(geometry IN MDSYS.SDO_GEOMETRY,
382 grdHeight IN SDO_NUMBER_ARRAY,
383 height IN SDO_NUMBER_ARRAY,
384 tol IN NUMBER,
385 optional3dSrid IN NUMBER)
386 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
387 AS LANGUAGE JAVA NAME
388 'oracle.spatial.util.Adapters.extrusion2(java.sql.Struct, oracle.spatial.type.SdoNumberArray, oracle.spatial.type.SdoNumberArray, oracle.sql.NUMBER, oracle.sql.NUMBER) return java.sql.Struct';
389
390
391
392 --
393 -- geodetic 3D related functions/procedures
394 --
395
396
397 FUNCTION populate_measure_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,
398 smax IN NUMBER,
399 flat IN NUMBER,
400 geog_crs_uom_factor IN NUMBER,
401 start_measure IN NUMBER,
402 end_measure IN NUMBER,
403 tolerance IN NUMBER)
404 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
405 AS LANGUAGE JAVA NAME
406 'oracle.spatial.geometry.LRSGeometryG3D.defineG3D(
407 java.sql.Struct,
408 oracle.sql.NUMBER,
409 oracle.sql.NUMBER,
410 oracle.sql.NUMBER,
411 oracle.sql.NUMBER,
412 oracle.sql.NUMBER,
413 oracle.sql.NUMBER) return java.sql.Struct';
414
415
416 FUNCTION locate_pt_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,
417 smax IN NUMBER,
418 flat IN NUMBER,
419 geog_crs_uom_factor IN NUMBER,
420 measure IN NUMBER,
421 tolerance IN NUMBER)
422 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
423 AS LANGUAGE JAVA NAME
424 'oracle.spatial.geometry.LRSGeometryG3D.locateG3D(
425 java.sql.Struct,
426 oracle.sql.NUMBER,
427 oracle.sql.NUMBER,
428 oracle.sql.NUMBER,
429 oracle.sql.NUMBER,
430 oracle.sql.NUMBER) return java.sql.Struct';
431
432 FUNCTION clip_geom_segment_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,
433 smax IN NUMBER,
434 flat IN NUMBER,
435 geog_crs_uom_factor IN NUMBER,
436 start_measure IN NUMBER,
437 end_measure IN NUMBER,
441 'oracle.spatial.geometry.LRSGeometryG3D.clipG3D(
438 tolerance IN NUMBER)
439 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
440 AS LANGUAGE JAVA NAME
442 java.sql.Struct,
443 oracle.sql.NUMBER,
444 oracle.sql.NUMBER,
445 oracle.sql.NUMBER,
446 oracle.sql.NUMBER,
447 oracle.sql.NUMBER,
448 oracle.sql.NUMBER) return java.sql.Struct';
449
450 FUNCTION project_pt_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,
451 smax IN NUMBER,
452 flat IN NUMBER,
453 geog_crs_uom_factor IN NUMBER,
454 point IN MDSYS.SDO_GEOMETRY,
455 tolerance IN NUMBER)
456 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
457 AS LANGUAGE JAVA NAME
458 'oracle.spatial.geometry.LRSGeometryG3D.projectG3D(
459 java.sql.Struct,
460 oracle.sql.NUMBER,
461 oracle.sql.NUMBER,
462 oracle.sql.NUMBER,
463 java.sql.Struct,
464 oracle.sql.NUMBER) return java.sql.Struct';
465
466 FUNCTION length_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,
467 smax IN NUMBER,
468 flat IN NUMBER,
469 geog_crs_uom_factor IN NUMBER,
470 tolerance IN NUMBER)
471 RETURN NUMBER PARALLEL_ENABLE
472 AS LANGUAGE JAVA NAME
473 'oracle.spatial.geometry.LRSGeometryG3D.lengthG3D(
474 java.sql.Struct,
475 oracle.sql.NUMBER,
476 oracle.sql.NUMBER,
477 oracle.sql.NUMBER,
478 oracle.sql.NUMBER) return oracle.sql.NUMBER';
479
480
481 ---
482 --- NDM sdo_net java stored procedure/function
483 ---
484
485 --
486 -- sdonetb.sql
487 --
488
489 -- private procedure to call java wrapper
490 PROCEDURE generate_partition_blobs_java(
491 network IN VARCHAR2,
492 link_level IN NUMBER,
493 partition_blob_table_name IN VARCHAR2,
494 include_user_data IN BOOLEAN,
495 commit_for_each_blob IN BOOLEAN,
496 perform_delta_update IN BOOLEAN)
497 AS LANGUAGE JAVA
498 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.generatePartitionBlobs(java.lang.String, int, java.lang.String, boolean, boolean, boolean)';
499
500
501 -- private procedure to call java wrapper
502 PROCEDURE generate_partition_blobs_java2(
503 network IN VARCHAR2,
504 partition_blob_table_name IN VARCHAR2,
505 include_user_data IN BOOLEAN,
506 commit_for_each_blob IN BOOLEAN,
507 perform_delta_update IN BOOLEAN)
508 AS LANGUAGE JAVA
509 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.generatePartitionBlobs(java.lang.String, java.lang.String, boolean, boolean, boolean)';
510
511
512 -- private procedure to call java wrapper
513 PROCEDURE generate_partition_blob_java(
514 network IN VARCHAR2,
515 link_level IN NUMBER,
516 partition_id IN NUMBER,
517 include_user_data IN BOOLEAN,
518 perform_delta_update IN BOOLEAN)
519 AS LANGUAGE JAVA
520 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.generatePartitionBlob(java.lang.String, int, int, boolean, boolean)';
521
522
523 -- private procedure to call java wrapper
524 PROCEDURE find_connected_components_java(
525 network IN VARCHAR2,
526 link_level IN NUMBER,
527 component_table_name IN VARCHAR2)
528 AS LANGUAGE JAVA
529 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.findConnectedComponents(java.lang.String, int, java.lang.String)';
530
531
532 FUNCTION find_conn_comp_part_java(
533 network IN VARCHAR2,
534 link_level IN NUMBER,
535 partition_id IN NUMBER,
536 start_comp_id IN NUMBER,
537 node_id_array OUT MDSYS.SDO_NUMBER_ARRAY, --SYS.ODCINUMBERLIST,
538 comp_id_array OUT MDSYS.SDO_NUMBER_ARRAY) -- SYS.ODCINUMBERLIST)
539 RETURN NUMBER
540 AS LANGUAGE JAVA
541 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.findConnectedComponentsInPartition(
542 java.lang.String,
543 int,
544 int,
545 int,
546 java.sql.Array[],
547 java.sql.Array[])
548 return int';
549
550 PROCEDURE set_max_java_heap_size(bytes NUMBER)
551 AS LANGUAGE JAVA NAME
552 'oracle.aurora.vm.OracleRuntime.setMaxMemorySize(long)';
553
554
555 PROCEDURE load_config_java( config_xml IN CLOB )
556 AS LANGUAGE JAVA
557 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.loadConfig(java.sql.Clob)';
558
559
560 FUNCTION get_partition_size_java( network IN VARCHAR2,
561 partition_id IN NUMBER,
562 link_level IN NUMBER,
563 inlcude_user_data IN BOOLEAN,
564 include_spatial_data IN BOOLEAN)
565 RETURN NUMBER
566 AS LANGUAGE JAVA
567 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.getPartitionSize(
568 java.lang.String,
569 int,
570 int,
571 boolean,
572 boolean) return long';
573
574 ---
575 --- prvtnetb.sql
576 ---
577
578 PROCEDURE set_logging_level_java( level IN NUMBER )
579 AS LANGUAGE JAVA
580 NAME 'oracle.spatial.network.lod.LODNetworkWrapper.setLoggingLevel(int)';
581
582
583 END;