Package google_maps_pkg

Variables, constants

const g_map_type_normal

g_map_type_normal constant varchar2(30):='G_NORMAL_MAP'

const g_map_type_satellite

g_map_type_satellite constant varchar2(30):='G_SATELLITE_MAP'

const g_map_type_hybrid

g_map_type_hybrid constant varchar2(30):='G_HYBRID_MAP'

const g_map_type_physical

g_map_type_physical constant varchar2(30):='G_PHYSICAL_MAP'

Functions, procedures

procedure set_api_key

procedure set_api_key(
    p_api_key in varchar2
)

set API key

function get_api_key

function get_api_key return varchar2

get API key

function get_geocode

function get_geocode(
    p_address in varchar2
) return sdo_geometry

get geocode from address

function get_point

function get_point(
    p_geocode in sdo_geometry,
    p_name in varchar2:=null
) return t_point

get point from geocode

function get_point

function get_point(
    p_address in varchar2
) return t_point

get point from address

function get_point

function get_point(
    p_longitude in number,
    p_longitude_direction in varchar2,
    p_latitude in number,
    p_latitude_direction in varchar2,
    p_name in varchar2:=null
) return t_point

get point from degree

procedure debug_geocode

procedure debug_geocode(
    p_address in varchar2
)

get geocode and print it

Types

record t_point

type t_point is record(
    longitude number,
    latitude number,
    name varchar2(255),
    info varchar2(2000)
)

varray t_point_list

type t_point_list is varray of t_point index by binary_integer