The Oracle APEX Guide Oracle Apex Guide RSS Feed
*
Accessibility

Background

Oracle Apex Table with Map Links

How to create an Oracle APEX Map Link by Coordinates

You can create a table link to a Google map using coordinates.

Use the decode statement in the pl SQL code to display the link with the Map icon as shown on the left. The pl SQL is shown in Screen 1 below. This will create the hyperlink for the map icon.

The coordinates are in a table as shown in Screen 2. The icon on this screen has a URL link to pass the map details as shown in the link on Screen 3.

The map display page has an HTML region with an iframe to an external web page as follows...

<iframe frameborder=0 scrolling="auto" width=930 height=430 src='http://www.yourwebsite.com/map.asp
?zoom=&P304_ZOOM.&lat=&P304_LAT.&lng=&P304_LNG.&info=&P304_LOCATION.'>
</iframe>

*

Oracle Apex pl SQL decode to display Map icon
Screen 1
Page Top

*

Oracle Apex Table with Map Coordinates
Screen 2
Page Top

*

Oracle Apex Link URL
Screen 3
Page Top

*

Display Google Maps by Post Code
Screen 4
Page Top

  *  
© RuleWorks - All Rights Reserved - Policy - - Sitemap