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.

MDSYS.SDO_UTIL dependencies on SDO_GEOMETRY

Line 11: Function expand_multi_point (geometry IN mdsys.sdo_geometry)

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;

Line 12: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 14: FUNCTION expand_geom (geometry IN mdsys.sdo_geometry)

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,

Line 15: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

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)

Line 17: FUNCTION extract(geometry IN mdsys.sdo_geometry,

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);

Line 20: 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)

Line 23: FUNCTION extract_all(geometry IN mdsys.sdo_geometry,

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:

Line 25: RETURN mdsys.sdo_geometry_array 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)

Line 28: FUNCTION append(geometry1 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:

Line 29: geometry2 IN MDSYS.sdo_geometry)

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,

Line 30: RETURN mdsys.sdo_geometry 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)

Line 33: FUNCTION ExtractVoids(geometry 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:

Line 35: 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;

Line 38: FUNCTION GetVertices(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)

Line 42: FUNCTION GetNumElem(geometry IN mdsys.sdo_geometry)

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(

Line 47: geom 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)

Line 51: FUNCTION GetNumVertices(geometry IN mdsys.sdo_geometry)

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,

Line 55: FUNCTION OuterLn(geometry IN mdsys.sdo_geometry,

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:

Line 57: RETURN mdsys.sdo_geometry DETERMINISTIC 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,

Line 60: FUNCTION RefineMGon(mgon 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);

Line 61: gon IN mdsys.sdo_geometry,

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:

Line 63: RETURN mdsys.sdo_geometry;

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,

Line 118: geometry IN MDSYS.SDO_GEOMETRY,

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:

Line 120: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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(

Line 125: geometry IN mdsys.sdo_geometry,

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;

Line 129: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

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,

Line 133: geometry IN mdsys.sdo_geometry,

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;

Line 137: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

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)

Line 141: FUNCTION polygontoline(geometry IN mdsys.sdo_geometry)

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,

Line 142: 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,

Line 145: geom1 IN mdsys.sdo_geometry,

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:

Line 146: geom2 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)

Line 148: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 150: FUNCTION remove_duplicates(geometry IN sdo_geometry, dim in sdo_dim_array)

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)

Line 151: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 153: FUNCTION remove_duplicate_vertices(geometry IN sdo_geometry,

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,

Line 155: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 157: FUNCTION circle_polygon (point MDSYS.SDO_GEOMETRY,

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,

Line 164: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 170: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 178: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 186: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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)

Line 188: FUNCTION point_at_bearing(start_point sdo_geometry,

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:

Line 191: 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,

Line 194: start_point sdo_geometry,

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) ;

Line 195: end_point sdo_geometry,

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:

Line 210: FUNCTION to_clob(Geometry IN MDSYS.SDO_GEOMETRY)

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;

Line 214: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 216: FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY)

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)

Line 219: FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 223: FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 227: FUNCTION to_gmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY,

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:

Line 232: FUNCTION to_gml311geometry(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)

Line 235: FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 239: FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 243: FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY,

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:

Line 248: FUNCTION to_gml321geometry(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)

Line 251: FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 255: FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 259: FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY,

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:

Line 264: FUNCTION to_kmlgeometry(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;

Line 267: FUNCTION to_wkbgeometry(geometry IN MDSYS.SDO_GEOMETRY)

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;

Line 270: FUNCTION to_wktgeometry(geometry IN MDSYS.SDO_GEOMETRY)

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;

Line 273: FUNCTION to_wktgeometry_varchar(geometry IN MDSYS.SDO_GEOMETRY)

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;

Line 277: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 280: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 283: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 286: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 289: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 292: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 295: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 299: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 303: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 307: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 311: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 314: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 317: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 320: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 323: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 327: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 331: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:
333: FUNCTION from_GML311geometry(geometry IN VARCHAR2,
334: coordOrder IN number)
335: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 335: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

331: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
332:
333: FUNCTION from_GML311geometry(geometry IN VARCHAR2,
334: coordOrder IN number)
335: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
336:
337: FUNCTION from_GML311geometry(geometry IN VARCHAR2, srsNameSpace IN varchar2,
338: coordOrder IN number)
339: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 339: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

335: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
336:
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:

Line 342: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 345: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 347: FUNCTION extrude(geometry IN MDSYS.SDO_GEOMETRY,

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)

Line 352: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 354: FUNCTION extrude(geometry IN MDSYS.SDO_GEOMETRY,

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)

Line 359: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 362: FUNCTION affinetransforms(geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 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,

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;

Line 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,

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:

Line 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)

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;

Line 368: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 370: FUNCTION extract3d(geometry IN MDSYS.SDO_GEOMETRY, label IN VARCHAR2)

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;

Line 371: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 373: FUNCTION getlabelbyelement(sourceGeometry IN MDSYS.SDO_GEOMETRY, queryElement IN MDSYS.SDO_GEOMETRY, tol IN NUMBER)

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;

Line 385: FUNCTION concat_lines (geometry1 IN MDSYS.SDO_GEOMETRY,

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,

Line 386: geometry2 IN MDSYS.SDO_GEOMETRY)

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,

Line 387: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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,

Line 395: FUNCTION reverse_linestring(geometry IN MDSYS.SDO_GEOMETRY)

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;

Line 396: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 398: FUNCTION internal_merge_linestrings(geometry IN MDSYS.SDO_GEOMETRY)

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;

Line 399: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC;

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:

Line 401: FUNCTION internal_merge_linestrings(geomArr IN MDSYS.SDO_GEOMETRY_ARRAY)

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)

Line 402: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC;

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;

Line 405: multilinestring IN MDSYS.SDO_GEOMETRY, element_index IN INTEGER)

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);

Line 406: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 471: FUNCTION remove_inner_rings(inpgeom SDO_GEOMETRY, inptol number)

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;

Line 472: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 474: FUNCTION quad_tiles(geom SDO_GEOMETRY, sdo_level number, tol number:=0.0000000005)

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.

Line 481: FUNCTION hybrid_tiles(geom SDO_GEOMETRY, sdo_level number := 4,

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)

Line 485: FUNCTION interior_point (geom SDO_GEOMETRY, tol number := 0.00000000005)

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;

Line 486: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 488: FUNCTION number_of_components(geometry SDO_GEOMETRY, requested_type varchar2)

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;

Line 491: FUNCTION get_2d_footprint(geometry SDO_GEOMETRY, tolerance number := 0.05)

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;

Line 492: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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:

Line 494: FUNCTION convert3007to3008(geometry sdo_geometry)

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;

Line 495: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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: -------------------------------------------------------------------------

Line 497: FUNCTION get_boundary(geometry in sdo_geometry)

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(

Line 498: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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)

Line 525: FUNCTION ToGnomonic(geom in sdo_geometry, longitude in number,

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,

Line 527: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

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;

Line 529: FUNCTION getNurbsApprox(geometry IN mdsys.sdo_geometry,

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:

Line 531: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

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;

Line 534: FUNCTION jsph_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,

Line 535: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

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,

Line 538: FUNCTION linear_key(geometry IN mdsys.sdo_geometry,

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:

Line 543: 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;