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_JAVA_STP dependencies on SDO_GEOMETRY

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

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,

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

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:

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

Line 17: 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' ;

Line 23: FUNCTION to_gml311geometry(Geometry IN MDSYS.SDO_GEOMETRY)

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,

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

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:

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

Line 37: 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' ;

Line 43: FUNCTION to_gml321geometry(Geometry IN MDSYS.SDO_GEOMETRY)

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,

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

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:

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

Line 57: 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' ;

Line 63: FUNCTION to_kmlgeometry(Geometry IN MDSYS.SDO_GEOMETRY)

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:

Line 69: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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)

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

Line 80: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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:

Line 86: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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)

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

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

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

Line 107: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 113: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 119: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 125: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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)

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

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

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

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

Line 151: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 157: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 163: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 169: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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)

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

Line 180: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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:

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

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,

Line 187: scaling IN VARCHAR2, Psc1 IN MDSYS.SDO_GEOMETRY, sx IN NUMBER, sy IN NUMBER, sz IN NUMBER,

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

Line 188: rotation IN VARCHAR2, P1 IN MDSYS.SDO_GEOMETRY, line1 IN MDSYS.SDO_GEOMETRY, angle IN NUMBER, dir IN NUMBER,

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

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

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,

Line 191: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

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

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:

Line 201: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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)

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

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:

Line 227: FUNCTION generate_buffer(geomobj IN mdsys.sdo_geometry,

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

Line 231: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 235: FUNCTION anyInteract3D(Geometry1 IN MDSYS.SDO_GEOMETRY,

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

Line 236: Geometry2 IN MDSYS.SDO_GEOMETRY,

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

Line 243: FUNCTION distance3D(Geometry1 IN MDSYS.SDO_GEOMETRY,

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,

Line 244: Geometry2 IN MDSYS.SDO_GEOMETRY,

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,

Line 254: FUNCTION length3D(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 265: FUNCTION area3D(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 275: FUNCTION volume3D(Geometry IN MDSYS.SDO_GEOMETRY,

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,

Line 286: FUNCTION validateGeom3D(Geometry IN MDSYS.SDO_GEOMETRY,

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

Line 305: FUNCTION closestPoints3D(Geometry1 IN MDSYS.SDO_GEOMETRY,

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,

Line 306: Geometry2 IN MDSYS.SDO_GEOMETRY,

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,

Line 312: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 316: FUNCTION centroid3D(Geometry IN MDSYS.SDO_GEOMETRY,

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
320: 'oracle.spatial.util.Adapters.centroid_3d(java.sql.Struct, oracle.sql.NUMBER) return java.sql.Struct';

Line 318: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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

Line 323: FUNCTION ring_union_approx(geom SDO_GEOMETRY, tol number)

319: AS LANGUAGE JAVA NAME
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
323: FUNCTION ring_union_approx(geom SDO_GEOMETRY, tol number)
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:

Line 324: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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
323: FUNCTION ring_union_approx(geom SDO_GEOMETRY, tol number)
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,

Line 328: FUNCTION inside3D(Geometry1 IN MDSYS.SDO_GEOMETRY,

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

Line 329: Geometry2 IN MDSYS.SDO_GEOMETRY,

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

Line 336: FUNCTION pctrclip(qry IN sdo_geometry,

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,

Line 345: function expandG3DGeoms(geom IN mdsys.sdo_geometry)

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:

Line 346: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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:

Line 351: FUNCTION internal_simplifyvw(geometry IN MDSYS.SDO_GEOMETRY,

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

Line 355: return MDSYS.SDO_GEOMETRY deterministic PARALLEL_ENABLE

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

Line 360: FUNCTION internal_getnurbsapprox(geometry IN MDSYS.SDO_GEOMETRY)

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:

Line 361: RETURN MDSYS.SDO_GEOMETRY deterministic PARALLEL_ENABLE

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)

Line 365: FUNCTION intl_to_wkbgeometry(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:

Line 370: FUNCTION intl_to_wktgeometry(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:

Line 375: FUNCTION intl_to_wktgeometry_varchar(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:

Line 381: FUNCTION intl_extrude(geometry IN MDSYS.SDO_GEOMETRY,

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)

Line 386: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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:

Line 397: FUNCTION populate_measure_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,

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,

Line 404: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 416: FUNCTION locate_pt_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,

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,

Line 422: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 432: FUNCTION clip_geom_segment_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,

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,

Line 439: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

435: geog_crs_uom_factor IN NUMBER,
436: start_measure IN NUMBER,
437: end_measure IN NUMBER,
438: tolerance IN NUMBER)
439: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE
440: AS LANGUAGE JAVA NAME
441: 'oracle.spatial.geometry.LRSGeometryG3D.clipG3D(
442: java.sql.Struct,
443: oracle.sql.NUMBER,

Line 450: FUNCTION project_pt_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,

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,

Line 454: point IN MDSYS.SDO_GEOMETRY,

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(

Line 456: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE

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,

Line 466: FUNCTION length_geo3d(geom_segment IN MDSYS.SDO_GEOMETRY,

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)