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_GCDR dependencies on SDO_GEO_ADDR

Line 72: -- the first matched address as a SDO_GEO_ADDR object

68: function batch_geocode(address_list in varchar2, gc_username in varchar2, max_result_count number)
69: return sdo_keywordarray deterministic PARALLEL_ENABLE;
70:
71: -- geocode an input address specified by address lines and return
72: -- the first matched address as a SDO_GEO_ADDR object
73: function geocode(
74: username varchar2,
75: addr_lines SDO_keywordArray,
76: country VARCHAR2,

Line 78: logging number default 0) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

74: username varchar2,
75: addr_lines SDO_keywordArray,
76: country VARCHAR2,
77: match_mode VARCHAR2,
78: logging number default 0) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
79:
80: -- geocode an input address specified by address lines and return
81: -- the the coordinates of the first matched address as sdo_geometry
82: function geocode_as_geometry(

Line 88: -- geocode an input address specified by a SDO_GEO_ADDR object and return

84: addr_lines SDO_keywordArray,
85: country VARCHAR2)
86: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
87:
88: -- geocode an input address specified by a SDO_GEO_ADDR object and return
89: -- the first matched address as a SDO_GEO_ADDR object
90: function geocode_addr(
91: gc_username varchar2,
92: address SDO_GEO_ADDR,

Line 89: -- the first matched address as a SDO_GEO_ADDR object

85: country VARCHAR2)
86: RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
87:
88: -- geocode an input address specified by a SDO_GEO_ADDR object and return
89: -- the first matched address as a SDO_GEO_ADDR object
90: function geocode_addr(
91: gc_username varchar2,
92: address SDO_GEO_ADDR,
93: logging number default 0) return SDO_geo_Addr deterministic PARALLEL_ENABLE;

Line 92: address SDO_GEO_ADDR,

88: -- geocode an input address specified by a SDO_GEO_ADDR object and return
89: -- the first matched address as a SDO_GEO_ADDR object
90: function geocode_addr(
91: gc_username varchar2,
92: address SDO_GEO_ADDR,
93: logging number default 0) return SDO_geo_Addr deterministic PARALLEL_ENABLE;
94:
95: -- geocode an input address specified by a address lines and return all
96: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects

Line 93: logging number default 0) return SDO_geo_Addr deterministic PARALLEL_ENABLE;

89: -- the first matched address as a SDO_GEO_ADDR object
90: function geocode_addr(
91: gc_username varchar2,
92: address SDO_GEO_ADDR,
93: logging number default 0) return SDO_geo_Addr deterministic PARALLEL_ENABLE;
94:
95: -- geocode an input address specified by a address lines and return all
96: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects
97: function geocode_all(

Line 96: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects

92: address SDO_GEO_ADDR,
93: logging number default 0) return SDO_geo_Addr deterministic PARALLEL_ENABLE;
94:
95: -- geocode an input address specified by a address lines and return all
96: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects
97: function geocode_all(
98: gc_username varchar2,
99: addr_lines SDO_keywordArray,
100: country VARCHAR2,

Line 104: -- geocode an input address specified by a SDO_GEO_ADDR object and return all

100: country VARCHAR2,
101: match_mode varchar2,
102: max_res_num number default 4000) return SDO_ADDR_ARRAY deterministic PARALLEL_ENABLE;
103:
104: -- geocode an input address specified by a SDO_GEO_ADDR object and return all
105: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects
106: function geocode_addr_all(
107: gc_username varchar2,
108: address SDO_GEO_ADDR,

Line 105: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects

101: match_mode varchar2,
102: max_res_num number default 4000) return SDO_ADDR_ARRAY deterministic PARALLEL_ENABLE;
103:
104: -- geocode an input address specified by a SDO_GEO_ADDR object and return all
105: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects
106: function geocode_addr_all(
107: gc_username varchar2,
108: address SDO_GEO_ADDR,
109: max_res_num number default 4000) return SDO_ADDR_ARRAY deterministic PARALLEL_ENABLE;

Line 108: address SDO_GEO_ADDR,

104: -- geocode an input address specified by a SDO_GEO_ADDR object and return all
105: -- matched addresses as a VARRAY of SDO_GEO_ADDR objects
106: function geocode_addr_all(
107: gc_username varchar2,
108: address SDO_GEO_ADDR,
109: max_res_num number default 4000) return SDO_ADDR_ARRAY deterministic PARALLEL_ENABLE;
110:
111: -- reverse-geocode a location specified by longitude and latitude into
112: -- address as a sdo_geo_addr object

Line 112: -- address as a sdo_geo_addr object

108: address SDO_GEO_ADDR,
109: max_res_num number default 4000) return SDO_ADDR_ARRAY deterministic PARALLEL_ENABLE;
110:
111: -- reverse-geocode a location specified by longitude and latitude into
112: -- address as a sdo_geo_addr object
113: function reverse_geocode(
114: username varchar2,
115: longitude number,
116: latitude number,

Line 117: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

113: function reverse_geocode(
114: username varchar2,
115: longitude number,
116: latitude number,
117: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
118:
119: -- reverse-geocode a location specified by longitude, latitude and srid into
120: -- address as a sdo_geo_addr object
121: function reverse_geocode(

Line 120: -- address as a sdo_geo_addr object

116: latitude number,
117: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
118:
119: -- reverse-geocode a location specified by longitude, latitude and srid into
120: -- address as a sdo_geo_addr object
121: function reverse_geocode(
122: username varchar2,
123: longitude number,
124: latitude number,

Line 126: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

122: username varchar2,
123: longitude number,
124: latitude number,
125: srid number DEFAULT -1,
126: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
127:
128: -- reverse-geocode a location specified by longitude and latitude into
129: -- address as a sdo_geo_addr object
130: function reverse_geocode(

Line 129: -- address as a sdo_geo_addr object

125: srid number DEFAULT -1,
126: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
127:
128: -- reverse-geocode a location specified by longitude and latitude into
129: -- address as a sdo_geo_addr object
130: function reverse_geocode(
131: username varchar2,
132: location sdo_geometry,
133: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

Line 133: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

129: -- address as a sdo_geo_addr object
130: function reverse_geocode(
131: username varchar2,
132: location sdo_geometry,
133: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
134:
135: -- reverse-geocode a location specified by longitude, latitude, into
136: -- address as a sdo_geo_addr object; address returned in lang
137: function reverse_geocode(

Line 136: -- address as a sdo_geo_addr object; address returned in lang

132: location sdo_geometry,
133: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
134:
135: -- reverse-geocode a location specified by longitude, latitude, into
136: -- address as a sdo_geo_addr object; address returned in lang
137: function reverse_geocode(
138: username varchar2,
139: longitude number,
140: latitude number,

Line 142: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

138: username varchar2,
139: longitude number,
140: latitude number,
141: language_ VARCHAR2,
142: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
143:
144: -- reverse-geocode a location specified by longitude, latitude, srid, into
145: -- address as a sdo_geo_addr object; address returned in lang
146: function reverse_geocode(

Line 145: -- address as a sdo_geo_addr object; address returned in lang

141: language_ VARCHAR2,
142: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
143:
144: -- reverse-geocode a location specified by longitude, latitude, srid, into
145: -- address as a sdo_geo_addr object; address returned in lang
146: function reverse_geocode(
147: username varchar2,
148: longitude number,
149: latitude number,

Line 152: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

148: longitude number,
149: latitude number,
150: srid number DEFAULT -1,
151: language_ VARCHAR2,
152: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
153:
154: -- reverse-geocode a location specified by geom into
155: -- address as a sdo_geo_addr object; address returned in lang
156: function reverse_geocode(

Line 155: -- address as a sdo_geo_addr object; address returned in lang

151: language_ VARCHAR2,
152: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
153:
154: -- reverse-geocode a location specified by geom into
155: -- address as a sdo_geo_addr object; address returned in lang
156: function reverse_geocode(
157: username varchar2,
158: location sdo_geometry,
159: language_ VARCHAR2,

Line 160: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;

156: function reverse_geocode(
157: username varchar2,
158: location sdo_geometry,
159: language_ VARCHAR2,
160: country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
161:
162: -- lists the countries available for geocoding. If more than one Geocoder is
163: -- installed, the UNION of countries available in each Geocoder is returned
164: FUNCTION list_countries RETURN SDO_STRING_ARRAY DETERMINISTIC PARALLEL_ENABLE;