eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: MDSYS.SDO_TOPO_MAP

Source


1 package SDO_TOPO_MAP AUTHID current_user AS
2 
3  PROCEDURE set_max_memory_size(bytes NUMBER)
4     AS LANGUAGE JAVA NAME
5     'oracle.aurora.vm.OracleRuntime.setMaxMemorySize(long)';
6  PROCEDURE create_topo_map(topology VARCHAR2, topo_map VARCHAR2,
7     number_of_edges NUMBER, number_of_nodes NUMBER,
8     number_of_faces NUMBER)
9     AS LANGUAGE JAVA NAME
10     'oracle.spatial.type.TopoMapWrapper.createTopoMap(java.lang.String,
11      java.lang.String, int, int, int)';
12  PROCEDURE create_topo_map(topology VARCHAR2, topo_map VARCHAR2)
13     AS LANGUAGE JAVA NAME
14     'oracle.spatial.type.TopoMapWrapper.createTopoMap(java.lang.String,
15      java.lang.String)';
16  FUNCTION list_topo_maps RETURN VARCHAR2 DETERMINISTIC
17     AS LANGUAGE JAVA NAME
18     'oracle.spatial.type.TopoMapWrapper.listTopoMaps()
19      return java.lang.String';
20  FUNCTION get_topo_name(topo_map VARCHAR2) RETURN VARCHAR2 DETERMINISTIC
21     AS LANGUAGE JAVA NAME
22     'oracle.spatial.type.TopoMapWrapper.getTopoName(java.lang.String)
23      return java.lang.String';
24  FUNCTION load_topo_map(topo_map VARCHAR2,
25     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER,
26     allow_updates VARCHAR2)
27     RETURN VARCHAR2 DETERMINISTIC
28     AS LANGUAGE JAVA NAME
29     'oracle.spatial.type.TopoMapWrapper.loadTopoMap(
30      java.lang.String,
31      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
32      oracle.sql.NUMBER, java.lang.String) return java.lang.String';
33  FUNCTION load_topo_map(topo_map VARCHAR2,
34     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER,
35     allow_updates VARCHAR2, build_indexes VARCHAR2)
36     RETURN VARCHAR2 DETERMINISTIC
37     AS LANGUAGE JAVA NAME
38     'oracle.spatial.type.TopoMapWrapper.loadTopoMap(
39      java.lang.String,
40      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
41      oracle.sql.NUMBER, java.lang.String, java.lang.String)
42     return java.lang.String';
43  FUNCTION load_topo_map(topo_map VARCHAR2,
44     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER,
45     allow_updates VARCHAR2, build_indexes VARCHAR2, next_load VARCHAR2)
46     RETURN VARCHAR2 DETERMINISTIC
47     AS LANGUAGE JAVA NAME
48     'oracle.spatial.type.TopoMapWrapper.loadTopoMap(
49      java.lang.String,
50      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
51      oracle.sql.NUMBER, java.lang.String, java.lang.String,  java.lang.String)
52     return java.lang.String';
53  FUNCTION load_topo_map(topo_map VARCHAR2, allow_updates VARCHAR2)
54     RETURN VARCHAR2 DETERMINISTIC
55     AS LANGUAGE JAVA NAME
56     'oracle.spatial.type.TopoMapWrapper.loadTopoMap(
57      java.lang.String, java.lang.String) return java.lang.String';
58  FUNCTION load_topo_map(topo_map VARCHAR2,
59     allow_updates VARCHAR2, build_indexes VARCHAR2)
60     RETURN VARCHAR2 DETERMINISTIC
61     AS LANGUAGE JAVA NAME
62     'oracle.spatial.type.TopoMapWrapper.loadTopoMap(
63      java.lang.String,
64      java.lang.String, java.lang.String) return java.lang.String';
65  PROCEDURE load_topo_map(topo_map VARCHAR2,
66     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER,
67     allow_updates VARCHAR2)
68     AS LANGUAGE JAVA NAME
69     'oracle.spatial.type.TopoMapWrapper.loadTopoMap2(
70      java.lang.String,
71      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
72      oracle.sql.NUMBER, java.lang.String)';
73  PROCEDURE load_topo_map(topo_map VARCHAR2,
74     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER,
75     allow_updates VARCHAR2, build_indexes VARCHAR2)
76     AS LANGUAGE JAVA NAME
77     'oracle.spatial.type.TopoMapWrapper.loadTopoMap2(
78      java.lang.String,
79      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
80      oracle.sql.NUMBER, java.lang.String, java.lang.String)';
81  PROCEDURE load_topo_map(topo_map VARCHAR2, allow_updates VARCHAR2)
82     AS LANGUAGE JAVA NAME
83     'oracle.spatial.type.TopoMapWrapper.loadTopoMap2(
84      java.lang.String, java.lang.String)';
85  PROCEDURE load_topo_map(topo_map VARCHAR2,
86     allow_updates VARCHAR2, build_indexes VARCHAR2)
87     AS LANGUAGE JAVA NAME
88     'oracle.spatial.type.TopoMapWrapper.loadTopoMap2(
89      java.lang.String,
90      java.lang.String, java.lang.String)';
91  PROCEDURE create_edge_index(topo_map VARCHAR2)
92     AS LANGUAGE JAVA NAME
93     'oracle.spatial.type.TopoMapWrapper.createEdgeIndex(
94      java.lang.String)';
95  PROCEDURE create_face_index(topo_map VARCHAR2)
96     AS LANGUAGE JAVA NAME
97     'oracle.spatial.type.TopoMapWrapper.createFaceIndex(
98      java.lang.String)';
99  PROCEDURE update_topo_map
100     AS LANGUAGE JAVA NAME
101     'oracle.spatial.type.TopoMapWrapper.updateTopoMap()';
102  PROCEDURE commit_topo_map
103     AS LANGUAGE JAVA NAME
104     'oracle.spatial.type.TopoMapWrapper.commitTopoMap()';
105  PROCEDURE rollback_topo_map
106     AS LANGUAGE JAVA NAME
107     'oracle.spatial.type.TopoMapWrapper.rollbackTopoMap()';
108  PROCEDURE clear_topo_map(topo_map VARCHAR2)
109     AS LANGUAGE JAVA NAME
110     'oracle.spatial.type.TopoMapWrapper.clearTopoMap(
111      java.lang.String)';
112  PROCEDURE drop_topo_map(topo_map VARCHAR2)
113     AS LANGUAGE JAVA NAME
114     'oracle.spatial.type.TopoMapWrapper.dropTopoMap(java.lang.String)';
115  FUNCTION validate_topo_map(topo_map VARCHAR2) RETURN VARCHAR2 DETERMINISTIC
116     AS LANGUAGE JAVA NAME
117     'oracle.spatial.type.TopoMapWrapper.validateTopoMap(
118      java.lang.String) return java.lang.String';
119  FUNCTION validate_topo_map(topo_map VARCHAR2, level NUMBER)
120     RETURN VARCHAR2 DETERMINISTIC
121     AS LANGUAGE JAVA NAME
122     'oracle.spatial.type.TopoMapWrapper.validateTopoMap(
123      java.lang.String, oracle.sql.NUMBER) return java.lang.String';
124 
125  FUNCTION search_face_rtree_topo_map(topo_map VARCHAR2, xmin NUMBER,
126     ymin NUMBER, xmax NUMBER, ymax NUMBER, capacity NUMBER)
127     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
128     AS LANGUAGE JAVA NAME
129     'oracle.spatial.type.TopoMapWrapper.searchFaceRTreeTopoMap(
130      java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER,
131      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER
132      ) return oracle.spatial.type.SdoNumberArray';
133 
134  FUNCTION search_edge_rtree_topo_map(topo_map VARCHAR2, xmin NUMBER,
135     ymin NUMBER, xmax NUMBER, ymax NUMBER, capacity NUMBER)
136     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
137     AS LANGUAGE JAVA NAME
138     'oracle.spatial.type.TopoMapWrapper.searchEdgeRTreeTopoMap(
139      java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER,
140      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER
141      ) return oracle.spatial.type.SdoNumberArray';
142 
143  FUNCTION get_node_changes
144     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
145     AS LANGUAGE JAVA NAME
146     'oracle.spatial.type.TopoMapWrapper.getNodeChanges()
147      return oracle.spatial.type.SdoNumberArray';
148  FUNCTION get_edge_changes
149     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
150     AS LANGUAGE JAVA NAME
151     'oracle.spatial.type.TopoMapWrapper.getEdgeChanges()
152      return oracle.spatial.type.SdoNumberArray';
153  FUNCTION get_face_changes
154     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
155     AS LANGUAGE JAVA NAME
156     'oracle.spatial.type.TopoMapWrapper.getFaceChanges()
157      return oracle.spatial.type.SdoNumberArray';
158  FUNCTION get_node_additions
159     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
160     AS LANGUAGE JAVA NAME
161     'oracle.spatial.type.TopoMapWrapper.getNodeAdditions()
162      return oracle.spatial.type.SdoNumberArray';
163  FUNCTION get_edge_additions
164     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
165     AS LANGUAGE JAVA NAME
166     'oracle.spatial.type.TopoMapWrapper.getEdgeAdditions()
167      return oracle.spatial.type.SdoNumberArray';
168  FUNCTION get_face_additions
169     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
170     AS LANGUAGE JAVA NAME
171     'oracle.spatial.type.TopoMapWrapper.getFaceAdditions()
172      return oracle.spatial.type.SdoNumberArray';
173  FUNCTION get_node_deletions
174     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
175     AS LANGUAGE JAVA NAME
176     'oracle.spatial.type.TopoMapWrapper.getNodeDeletions()
177      return oracle.spatial.type.SdoNumberArray';
178  FUNCTION get_edge_deletions
179     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
180     AS LANGUAGE JAVA NAME
181     'oracle.spatial.type.TopoMapWrapper.getEdgeDeletions()
182      return oracle.spatial.type.SdoNumberArray';
183  FUNCTION get_face_deletions
184     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
185     AS LANGUAGE JAVA NAME
186     'oracle.spatial.type.TopoMapWrapper.getFaceDeletions()
187      return oracle.spatial.type.SdoNumberArray';
188 
189  FUNCTION validate_topology(topology VARCHAR2)
190     RETURN VARCHAR2 DETERMINISTIC
191     AS LANGUAGE JAVA NAME
192     'oracle.spatial.type.TopoMapWrapper.validateTopology(
193      java.lang.String) return java.lang.String';
194  FUNCTION validate_topology(topology VARCHAR2, prevent_updates VARCHAR2)
195     RETURN VARCHAR2 DETERMINISTIC
196     AS LANGUAGE JAVA NAME
197     'oracle.spatial.type.TopoMapWrapper.validateTopology(
198      java.lang.String, java.lang.String) return java.lang.String';
199  FUNCTION validate_topology(topology VARCHAR2, prevent_updates VARCHAR2,
200     level NUMBER) RETURN VARCHAR2 DETERMINISTIC
201     AS LANGUAGE JAVA NAME
202     'oracle.spatial.type.TopoMapWrapper.validateTopology(
203      java.lang.String, java.lang.String, oracle.sql.NUMBER)
204      return java.lang.String';
205  FUNCTION validate_topology(topology VARCHAR2,
206     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER) RETURN VARCHAR2
207     AS LANGUAGE JAVA NAME
208     'oracle.spatial.type.TopoMapWrapper.validateTopology(
209      java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER,
210      oracle.sql.NUMBER, oracle.sql.NUMBER) return java.lang.String';
211  FUNCTION validate_topology(topology VARCHAR2,
212     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER,
213     prevent_updates VARCHAR2) RETURN VARCHAR2 DETERMINISTIC
214     AS LANGUAGE JAVA NAME
215     'oracle.spatial.type.TopoMapWrapper.validateTopology(
216      java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER,
217      oracle.sql.NUMBER, oracle.sql.NUMBER, java.lang.String)
218      return java.lang.String';
219  FUNCTION validate_topology(topology VARCHAR2,
220     xmin NUMBER, ymin NUMBER, xmax NUMBER, ymax NUMBER,
221     prevent_updates VARCHAR2, level NUMBER) RETURN VARCHAR2 DETERMINISTIC
222     AS LANGUAGE JAVA NAME
223     'oracle.spatial.type.TopoMapWrapper.validateTopology(
224      java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER,
225      oracle.sql.NUMBER, oracle.sql.NUMBER, java.lang.String,
226      oracle.sql.NUMBER) return java.lang.String';
227 
228  FUNCTION add_edge(topology VARCHAR2,
229     node_id1 NUMBER, node_id2 NUMBER, geom SDO_GEOMETRY)
230     RETURN NUMBER DETERMINISTIC
231     AS LANGUAGE JAVA NAME
232     'oracle.spatial.type.TopoMapWrapper.addEdge(java.lang.String,
233      oracle.sql.NUMBER, oracle.sql.NUMBER,
234      oracle.spatial.type.SdoGeometry) return oracle.sql.NUMBER';
235  FUNCTION add_loop(topology VARCHAR2,
236     node_id NUMBER, geom SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
237     AS LANGUAGE JAVA NAME
238     'oracle.spatial.type.TopoMapWrapper.addLoop(java.lang.String,
239      oracle.sql.NUMBER,
240      oracle.spatial.type.SdoGeometry) return oracle.sql.NUMBER';
241  FUNCTION get_edge_coords(topology VARCHAR2, topo_map VARCHAR2,
242     edge_id NUMBER) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
243     AS LANGUAGE JAVA NAME
244     'oracle.spatial.type.TopoMapWrapper.getEdgeCoords(java.lang.String,
245      java.lang.String, oracle.sql.NUMBER)
246      return oracle.spatial.type.SdoNumberArray';
247  FUNCTION add_node(topology VARCHAR2,
248     edge_id NUMBER, point SDO_GEOMETRY, coord_index NUMBER,
249     is_new_shape_point VARCHAR2) RETURN NUMBER DETERMINISTIC
250     AS LANGUAGE JAVA NAME
251     'oracle.spatial.type.TopoMapWrapper.addNode(java.lang.String,
252      oracle.sql.NUMBER,
253      oracle.spatial.type.SdoGeometry, int, java.lang.String)
254      return oracle.sql.NUMBER';
255  FUNCTION add_node(topology VARCHAR2,
256     edge_id NUMBER, x NUMBER, Y NUMBER, coord_index NUMBER,
257     is_new_shape_point VARCHAR2) RETURN NUMBER DETERMINISTIC
258     AS LANGUAGE JAVA NAME
259     'oracle.spatial.type.TopoMapWrapper.addNode(java.lang.String,
260      oracle.sql.NUMBER, oracle.sql.NUMBER,
261      oracle.sql.NUMBER, int, java.lang.String)
262      return oracle.sql.NUMBER';
263  FUNCTION add_isolated_node(topology VARCHAR2,
264     face_id NUMBER, point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
265     AS LANGUAGE JAVA NAME
266     'oracle.spatial.type.TopoMapWrapper.addIsolatedNode(
267      java.lang.String, oracle.sql.NUMBER,
268      oracle.spatial.type.SdoGeometry) return oracle.sql.NUMBER';
269  FUNCTION add_isolated_node(topology VARCHAR2,
270     face_id NUMBER, x NUMBER, y NUMBER) RETURN NUMBER DETERMINISTIC
271     AS LANGUAGE JAVA NAME
272     'oracle.spatial.type.TopoMapWrapper.addIsolatedNode(
273      java.lang.String, oracle.sql.NUMBER,
274      oracle.sql.NUMBER, oracle.sql.NUMBER) return oracle.sql.NUMBER';
275  FUNCTION add_isolated_node(topology VARCHAR2,
276     point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
277     AS LANGUAGE JAVA NAME
278     'oracle.spatial.type.TopoMapWrapper.addIsolatedNode(
279      java.lang.String,
280      oracle.spatial.type.SdoGeometry) return oracle.sql.NUMBER';
281  FUNCTION add_isolated_node(topology VARCHAR2,
282     x NUMBER, y NUMBER) RETURN NUMBER DETERMINISTIC
283     AS LANGUAGE JAVA NAME
284     'oracle.spatial.type.TopoMapWrapper.addIsolatedNode(
285      java.lang.String, oracle.sql.NUMBER,
286      oracle.sql.NUMBER) return oracle.sql.NUMBER';
287  FUNCTION get_node_coord(topology VARCHAR2, topo_map VARCHAR2,
288     node_id NUMBER) RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
289     AS LANGUAGE JAVA NAME
290     'oracle.spatial.type.TopoMapWrapper.getNodeCoord(java.lang.String,
291      java.lang.String, oracle.sql.NUMBER)
292      return oracle.spatial.type.SdoGeometry';
293  PROCEDURE move_node(topology VARCHAR2,
294     node_id NUMBER, edges_coords SDO_EDGE_ARRAY)
295     AS LANGUAGE JAVA NAME
296     'oracle.spatial.type.TopoMapWrapper.moveNode(
297      java.lang.String, oracle.sql.NUMBER,
298      oracle.spatial.type.SdoEdgeArray)';
299  PROCEDURE move_node(topology VARCHAR2,
300     node_id NUMBER, edges_coords SDO_EDGE_ARRAY,
301     moved_iso_nodes OUT SDO_NUMBER_ARRAY,
302     moved_iso_edges OUT SDO_NUMBER_ARRAY,
303     allow_iso_moves VARCHAR2)
304     AS LANGUAGE JAVA NAME
305     'oracle.spatial.type.TopoMapWrapper.moveNode(
306      java.lang.String, oracle.sql.NUMBER,
307      oracle.spatial.type.SdoEdgeArray,
308      oracle.spatial.type.SdoNumberArray[],
309      oracle.spatial.type.SdoNumberArray[],
310      java.lang.String)';
311  PROCEDURE move_isolated_node(topology VARCHAR2,
312     node_id NUMBER, point SDO_GEOMETRY)
313     AS LANGUAGE JAVA NAME
314     'oracle.spatial.type.TopoMapWrapper.moveIsolatedNode(
315      java.lang.String, oracle.sql.NUMBER,
316      oracle.spatial.type.SdoGeometry)';
317  PROCEDURE move_isolated_node(topology VARCHAR2,
318     node_id NUMBER, point SDO_GEOMETRY,
319                 allow_face_change VARCHAR2)
320     AS LANGUAGE JAVA NAME
321     'oracle.spatial.type.TopoMapWrapper.moveIsolatedNode(
322      java.lang.String, oracle.sql.NUMBER,
323      oracle.spatial.type.SdoGeometry,java.lang.String)';
324  PROCEDURE move_isolated_node(topology VARCHAR2,
325     node_id NUMBER, x NUMBER, y NUMBER)
326     AS LANGUAGE JAVA NAME
330  PROCEDURE move_isolated_node(topology VARCHAR2,
327     'oracle.spatial.type.TopoMapWrapper.moveIsolatedNode(
328      java.lang.String, oracle.sql.NUMBER,
329      oracle.sql.NUMBER, oracle.sql.NUMBER)';
331     node_id NUMBER, x NUMBER, y NUMBER,
332                allow_face_change VARCHAR2)
333     AS LANGUAGE JAVA NAME
334     'oracle.spatial.type.TopoMapWrapper.moveIsolatedNode(
335      java.lang.String, oracle.sql.NUMBER,
336      oracle.sql.NUMBER, oracle.sql.NUMBER,java.lang.String)';
337  PROCEDURE remove_node(topology VARCHAR2,
338     node_id NUMBER)
339     AS LANGUAGE JAVA NAME
340     'oracle.spatial.type.TopoMapWrapper.removeNode(
341      java.lang.String, oracle.sql.NUMBER)';
342  PROCEDURE remove_obsolete_nodes(topology VARCHAR2)
343     AS LANGUAGE JAVA NAME
344     'oracle.spatial.type.TopoMapWrapper.removeObsoleteNodes(
345      java.lang.String)';
346  PROCEDURE move_edge(topology VARCHAR2,
347     edge_id NUMBER, s_node_id NUMBER, t_node_id NUMBER,
348     edge_coords SDO_NUMBER_ARRAY)
349     AS LANGUAGE JAVA NAME
350     'oracle.spatial.type.TopoMapWrapper.moveEdge(
351      java.lang.String,
352      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
353      oracle.spatial.type.SdoNumberArray)';
354  PROCEDURE move_edge(topology VARCHAR2,
355     edge_id NUMBER, s_node_id NUMBER, t_node_id NUMBER,
356     edge_coords SDO_NUMBER_ARRAY,
357     moved_iso_nodes OUT SDO_NUMBER_ARRAY,
358     moved_iso_edges OUT SDO_NUMBER_ARRAY,
359     allow_iso_moves VARCHAR2)
360     AS LANGUAGE JAVA NAME
361     'oracle.spatial.type.TopoMapWrapper.moveEdge(
362      java.lang.String,
363      oracle.sql.NUMBER, oracle.sql.NUMBER, oracle.sql.NUMBER,
364      oracle.spatial.type.SdoNumberArray,
365      oracle.spatial.type.SdoNumberArray[],
366      oracle.spatial.type.SdoNumberArray[],
367      java.lang.String)';
368  PROCEDURE remove_edge(topology VARCHAR2,
369     edge_id NUMBER)
370     AS LANGUAGE JAVA NAME
371     'oracle.spatial.type.TopoMapWrapper.removeEdge(
372      java.lang.String, oracle.sql.NUMBER)';
373  PROCEDURE change_edge_coords(topology VARCHAR2,
374     edge_id NUMBER, geom SDO_GEOMETRY)
375     AS LANGUAGE JAVA NAME
376     'oracle.spatial.type.TopoMapWrapper.changeEdgeCoords(
377      java.lang.String, oracle.sql.NUMBER,
378      oracle.spatial.type.SdoGeometry)';
379  PROCEDURE change_edge_coords(topology VARCHAR2,
380     edge_id NUMBER, geom SDO_GEOMETRY,
381     moved_iso_nodes OUT SDO_NUMBER_ARRAY,
382     moved_iso_edges OUT SDO_NUMBER_ARRAY,
383     allow_iso_moves VARCHAR2)
384     AS LANGUAGE JAVA NAME
385     'oracle.spatial.type.TopoMapWrapper.changeEdgeCoords(
386      java.lang.String, oracle.sql.NUMBER,
387      oracle.spatial.type.SdoGeometry,
388      oracle.spatial.type.SdoNumberArray[],
389      oracle.spatial.type.SdoNumberArray[],
390      java.lang.String)';
391  FUNCTION add_point_geometry(topology VARCHAR2,
392     point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
393     AS LANGUAGE JAVA NAME
394     'oracle.spatial.type.TopoMapWrapper.addPointGeometry(
395      java.lang.String, oracle.spatial.type.SdoGeometry)
396      return oracle.sql.NUMBER';
397  FUNCTION add_point_geometry(topology VARCHAR2,
398     coord SDO_NUMBER_ARRAY) RETURN NUMBER DETERMINISTIC
399     AS LANGUAGE JAVA NAME
400     'oracle.spatial.type.TopoMapWrapper.addPointGeometry(
401      java.lang.String, oracle.spatial.type.SdoNumberArray)
402      return oracle.sql.NUMBER';
403  FUNCTION add_linear_geometry(topology VARCHAR2,
404     curve SDO_GEOMETRY) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
405     AS LANGUAGE JAVA NAME
406     'oracle.spatial.type.TopoMapWrapper.addLinearGeometry(
407      java.lang.String, oracle.spatial.type.SdoGeometry)
408      return oracle.spatial.type.SdoNumberArray';
409  FUNCTION add_linear_geometry(topology VARCHAR2,
410     coords SDO_NUMBER_ARRAY) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
411     AS LANGUAGE JAVA NAME
412     'oracle.spatial.type.TopoMapWrapper.addLinearGeometry(
413      java.lang.String, oracle.spatial.type.SdoNumberArray)
414      return oracle.spatial.type.SdoNumberArray';
415  FUNCTION add_polygon_geometry(topology VARCHAR2,
416     polygon SDO_GEOMETRY) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
417     AS LANGUAGE JAVA NAME
418     'oracle.spatial.type.TopoMapWrapper.addPolygonGeometry(
419      java.lang.String, oracle.spatial.type.SdoGeometry)
420      return oracle.spatial.type.SdoNumberArray';
421  FUNCTION add_polygon_geometry(topology VARCHAR2,
422     coords SDO_NUMBER_ARRAY) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
423     AS LANGUAGE JAVA NAME
424     'oracle.spatial.type.TopoMapWrapper.addPolygonGeometry(
425       java.lang.String, oracle.spatial.type.SdoNumberArray)
426      return oracle.spatial.type.SdoNumberArray';
427 
428  FUNCTION create_feature(topology VARCHAR2, table_name VARCHAR2,
429     column_name VARCHAR2, geom SDO_GEOMETRY)
430     RETURN SDO_TOPO_GEOMETRY DETERMINISTIC
431     AS LANGUAGE JAVA NAME
432     'oracle.spatial.type.TopoMapWrapper.createFeature(
433       java.lang.String, java.lang.String, java.lang.String,
434       oracle.spatial.type.SdoGeometry)
435      return oracle.spatial.type.SdoTopoGeometry';
436  FUNCTION create_feature(topology VARCHAR2, table_name VARCHAR2,
437     column_name VARCHAR2, geom SDO_GEOMETRY, snapFeature number)
438     RETURN SDO_TOPO_GEOMETRY DETERMINISTIC
439     AS LANGUAGE JAVA NAME
440     'oracle.spatial.type.TopoMapWrapper.createFeature(
441       java.lang.String, java.lang.String, java.lang.String,
445     column_name VARCHAR2, dml_condition VARCHAR2)
442       oracle.spatial.type.SdoGeometry,oracle.sql.NUMBER)
443      return oracle.spatial.type.SdoTopoGeometry';
444  FUNCTION create_feature(topology VARCHAR2, table_name VARCHAR2,
446     RETURN SDO_TOPO_GEOMETRY DETERMINISTIC
447     AS LANGUAGE JAVA NAME
448     'oracle.spatial.type.TopoMapWrapper.createFeature(
449       java.lang.String, java.lang.String, java.lang.String,
450       java.lang.String)
451      return oracle.spatial.type.SdoTopoGeometry';
452 
453  FUNCTION get_containing_face(topology VARCHAR2, topo_map VARCHAR2,
454     point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
455     AS LANGUAGE JAVA NAME
456     'oracle.spatial.type.TopoMapWrapper.getContainingFace(
457      java.lang.String, java.lang.String,
458      oracle.spatial.type.SdoGeometry)  return oracle.sql.NUMBER';
459 
460  FUNCTION get_containing_face(topology VARCHAR2, topo_map VARCHAR2,
461     point SDO_GEOMETRY, allow_iso_coincidence varchar2)
462    RETURN NUMBER DETERMINISTIC
463     AS LANGUAGE JAVA NAME
464     'oracle.spatial.type.TopoMapWrapper.getContainingFace(
465      java.lang.String, java.lang.String,
466      oracle.spatial.type.SdoGeometry, java.lang.String)
467     return oracle.sql.NUMBER';
468 
469  FUNCTION get_containing_face(topology VARCHAR2, topo_map VARCHAR2,
470     x NUMBER, y NUMBER) RETURN NUMBER DETERMINISTIC
471     AS LANGUAGE JAVA NAME
472     'oracle.spatial.type.TopoMapWrapper.getContainingFace(
473      java.lang.String, java.lang.String, oracle.sql.NUMBER,
474      oracle.sql.NUMBER) return oracle.sql.NUMBER';
475  FUNCTION get_node_star(topology VARCHAR2, topo_map VARCHAR2,
476     node_id NUMBER) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
477     AS LANGUAGE JAVA NAME
478     'oracle.spatial.type.TopoMapWrapper.getNodeStar(
479      java.lang.String, java.lang.String, oracle.sql.NUMBER)
480      return oracle.spatial.type.SdoNumberArray';
481  FUNCTION get_node_face_star(topology VARCHAR2, topo_map VARCHAR2,
482     node_id NUMBER) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
483     AS LANGUAGE JAVA NAME
484     'oracle.spatial.type.TopoMapWrapper.getNodeFaceStar(
485      java.lang.String, java.lang.String, oracle.sql.NUMBER)
486      return oracle.spatial.type.SdoNumberArray';
487  FUNCTION get_edge_nodes(topology VARCHAR2, topo_map VARCHAR2,
488     edge_id NUMBER) RETURN SDO_NUMBER_ARRAY DETERMINISTIC
489     AS LANGUAGE JAVA NAME
490     'oracle.spatial.type.TopoMapWrapper.getEdgeNodes(
491      java.lang.String, java.lang.String, oracle.sql.NUMBER)
492      return oracle.spatial.type.SdoNumberArray';
493  FUNCTION get_face_boundary(topology VARCHAR2, topo_map VARCHAR2,
494     face_id NUMBER, opiton NUMBER)
495     RETURN SDO_NUMBER_ARRAY DETERMINISTIC
496     AS LANGUAGE JAVA NAME
497     'oracle.spatial.type.TopoMapWrapper.getFaceBoundary(
498      java.lang.String, java.lang.String, oracle.sql.NUMBER, oracle.sql.NUMBER)
499      return oracle.spatial.type.SdoNumberArray';
500 
501  FUNCTION get_nearest_node(topology VARCHAR2, topo_map VARCHAR2,
502     point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
503     AS LANGUAGE JAVA NAME
504     'oracle.spatial.type.TopoMapWrapper.getNearestNode(
505      java.lang.String, java.lang.String, oracle.spatial.type.SdoGeometry)
506      return oracle.sql.NUMBER';
507  FUNCTION get_nearest_node(topology VARCHAR2, topo_map VARCHAR2,
508     x NUMBER, y NUMBER) RETURN NUMBER DETERMINISTIC
509     AS LANGUAGE JAVA NAME
510     'oracle.spatial.type.TopoMapWrapper.getNearestNode(
511      java.lang.String, java.lang.String, oracle.sql.NUMBER,
512      oracle.sql.NUMBER) return oracle.sql.NUMBER';
513  FUNCTION get_nearest_edge(topology VARCHAR2, topo_map VARCHAR2,
514     point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
515     AS LANGUAGE JAVA NAME
516     'oracle.spatial.type.TopoMapWrapper.getNearestEdge(
517      java.lang.String, java.lang.String, oracle.spatial.type.SdoGeometry)
518      return oracle.sql.NUMBER';
519  FUNCTION get_nearest_edge(topology VARCHAR2, topo_map VARCHAR2,
520     x NUMBER, y NUMBER) RETURN NUMBER DETERMINISTIC
521     AS LANGUAGE JAVA NAME
522     'oracle.spatial.type.TopoMapWrapper.getNearestEdge(
523      java.lang.String, java.lang.String, oracle.sql.NUMBER,
524      oracle.sql.NUMBER) return oracle.sql.NUMBER';
525 
526  FUNCTION get_nearest_node_in_cache(topo_map VARCHAR2,
527     x NUMBER, y NUMBER) RETURN NUMBER DETERMINISTIC
528     AS LANGUAGE JAVA NAME
529     'oracle.spatial.type.TopoMapWrapper.getNearestNodeInCache(
530      java.lang.String, oracle.sql.NUMBER,
531      oracle.sql.NUMBER) return oracle.sql.NUMBER';
532  FUNCTION get_nearest_node_in_cache(topo_map VARCHAR2,
533     point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
534     AS LANGUAGE JAVA NAME
535     'oracle.spatial.type.TopoMapWrapper.getNearestNodeInCache(
536      java.lang.String, oracle.spatial.type.SdoGeometry)
537     return oracle.sql.NUMBER';
538 
539  FUNCTION get_nearest_edge_in_cache(topo_map VARCHAR2,
540     x NUMBER, y NUMBER) RETURN NUMBER DETERMINISTIC
541     AS LANGUAGE JAVA NAME
542     'oracle.spatial.type.TopoMapWrapper.getNearestEdgeInCache(
543      java.lang.String, oracle.sql.NUMBER,
544      oracle.sql.NUMBER) return oracle.sql.NUMBER';
545  FUNCTION get_nearest_edge_in_cache(topo_map VARCHAR2,
546     point SDO_GEOMETRY) RETURN NUMBER DETERMINISTIC
547     AS LANGUAGE JAVA NAME
548     'oracle.spatial.type.TopoMapWrapper.getNearestEdgeInCache(
549      java.lang.String, oracle.spatial.type.SdoGeometry)
550     return oracle.sql.NUMBER';
551 
555      return oracle.sql.NUMBER';
552  FUNCTION get_topo_transaction_id RETURN NUMBER DETERMINISTIC
553     AS LANGUAGE JAVA NAME
554     'oracle.spatial.type.TopoMapWrapper.getTopoTransactionId()
556 
557 END SDO_TOPO_MAP;