Forum Stats

  • 3,757,803 Users
  • 2,251,268 Discussions
  • 7,869,920 Comments

Discussions

Geolocation Showcase: Oracle Elocation Geocoder Service

Robert Schaefer
Robert Schaefer Member Posts: 39 Bronze Badge

Hello,

how can i activate the Oracle Elocation Geocoder Service? The information in the latest version of the sample app seems to be out of date. 

I enable the APEX engine to connect to maps.oracle.com via http:

begin
	 dbms_network_acl_admin.append_host_ace(
	  host    => 'maps.oracle.com',
	  ace    => xs$ace_type(
	   privilege_list  => xs$name_list('http')
	  ,granted      => true
	  ,principal_name  => 'APEX_200200'
	  ,principal_type  => XS_ACL.PTYPE_DB
	  ));
	end;
	/

This is not enough, i still receive the error that the request is blocked by ACL. When i enable all domains the request is no longer blocked:

begin
	 dbms_network_acl_admin.append_host_ace(
	  host    => '*',
	  ace    => xs$ace_type(
	   privilege_list  => xs$name_list('http')
	  ,granted      => true
	  ,principal_name  => 'APEX_200200'
	  ,principal_type  => XS_ACL.PTYPE_DB
	  ));
	end;
	/


Obviously the wrapped package EBA_SPATIAL_GCDR_PKG uses another domain besides maps.oracle.com. Which one?

Additionally the certificate has to be uploaded in the wallet (missing in documentation). When i upload the maps.oracle.com-certificate in my wallet, i still receive "ORA-29024: Certificate validation failure". So on which domains are the http-requests in EBA_SPATIAL_GCDR_PKG executed?

Best regards

Robert

Comments