The Oracle APEX Guide
Accessibility

Background

How to create an Oracle APEX Map Link by Coordinates

Oracle Apex Table with Map Links
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

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