With that in mind, this was using Oracle Apex v4.2.1 and Maps API version 3
It actually isn't too hard to achieve, but there's one or two points not clear in the sites I read.
Once you have Apex running, all you need then is an access key from Google API. In version 3 you do not need to put the key reference in, so I'm not sure how it knows it's your key! Perhaps through the referrer sites.
This example assumes many markers, on a single map, and the marker details are kept in a database table
Anyway, here goes....
- SQL Workshop > Object Browser
- Create Procedure
- Give your Procedure a name "MAPIT"
- You can uncheck Arguments, we don't need any for this example
- Next we'll need to enter some PL/SQL code ..
- The ; at the end of the SQL statement
- The canvas name, just make sure it's consistent
- The height and width of the DIV "map-canvas". Change to match your page
MAPIT;That's it. Make sure you've got geo coded data in your tables. (There's plenty of blogs about geo-coding on the fly)