tag:blogger.com,1999:blog-4729137724839062082024-03-14T01:21:22.321-07:00PL/GMAPSA PL/SQL package built over the Google Maps API.
<br>
Perfect integration with Oracle Application Express (APEX).Louis-Guillaumehttp://www.blogger.com/profile/06491876959467764686noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-472913772483906208.post-85922126240902164822008-10-14T12:30:00.000-07:002008-10-14T13:44:38.429-07:00project hosted by Google CodeI needed a tool for managing PL/GMAPS project. Again, I turned my self to Google.<br />It has a service called <a href="http://code.google.com/">Google Code</a>. I decided to give it a try. I created a new project that can be visited at <a href="http://code.google.com/p/plgmaps">code.google.com/p/plgmaps</a>.<br /><br />Blogger, Code, Analytics, AdSense, Maps ... all of them are great tools! :) Give them a try!Louis-Guillaumehttp://www.blogger.com/profile/06491876959467764686noreply@blogger.com12tag:blogger.com,1999:blog-472913772483906208.post-62738090652929357182008-09-07T23:00:00.000-07:002008-09-08T11:40:49.831-07:00Traffic informationHi,<br /><br />One of the great features of Google Maps is the traffic information that can be displayed on the map. Unfortunately, traffic information are only available for the USA. People living outside the USA can access the information but I don't think it will be really useful to them.<br /><br /><span style="font-weight: bold;">1) PL/SQL Region - PLGMAPS code</span><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_eGo1vRawUKs/SMVvoft9m5I/AAAAAAAAAL8/eMKRoE6x12s/s1600-h/code.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://2.bp.blogspot.com/_eGo1vRawUKs/SMVvoft9m5I/AAAAAAAAAL8/eMKRoE6x12s/s200/code.JPG" alt="" id="BLOGGER_PHOTO_ID_5243720082642541458" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="font-weight: bold;">2) Example</span><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_eGo1vRawUKs/SMVvxX3uBYI/AAAAAAAAAME/4e-JTpT-6Ws/s1600-h/example.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://3.bp.blogspot.com/_eGo1vRawUKs/SMVvxX3uBYI/AAAAAAAAAME/4e-JTpT-6Ws/s200/example.JPG" alt="" id="BLOGGER_PHOTO_ID_5243720235154802050" border="0" /></a>As you can see on this map, the information might not be accurate all the time. In this case, we see a car incident that is expected to end in December 2008. No one can survive a 3 months car crash! ;)Louis-Guillaumehttp://www.blogger.com/profile/06491876959467764686noreply@blogger.com0tag:blogger.com,1999:blog-472913772483906208.post-40144028524859924732008-09-07T22:57:00.000-07:002008-09-08T11:19:05.684-07:00How to debug - Hello WorldHi,<br /><br />To facilitate the debugging of Google Maps integration to your web page, the official Google Maps API contains functions to print information to a log window.<br />This example will show 3 ways to print information to the log window.<br />I will add a "print to log" functionality to the major procedures of PLGMAPS. For example, if you add markers to the map, the log window will display the coordinates of the markers. Without this log window, you'll have to read the generated JavaScript code and find the information your are looking for.<br /><br /><span style="font-weight: bold;">1) PL/SQL Region - PLGMAPS code</span><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_eGo1vRawUKs/SMVq1y_8w9I/AAAAAAAAALs/OexfMS6BMJM/s1600-h/code.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://3.bp.blogspot.com/_eGo1vRawUKs/SMVq1y_8w9I/AAAAAAAAALs/OexfMS6BMJM/s200/code.JPG" alt="" id="BLOGGER_PHOTO_ID_5243714813598417874" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="font-weight: bold;">2) Example</span><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_eGo1vRawUKs/SMVq9pFqHrI/AAAAAAAAAL0/jbfTDqUgcao/s1600-h/example.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://4.bp.blogspot.com/_eGo1vRawUKs/SMVq9pFqHrI/AAAAAAAAAL0/jbfTDqUgcao/s200/example.JPG" alt="" id="BLOGGER_PHOTO_ID_5243714948376960690" border="0" /></a>Louis-Guillaumehttp://www.blogger.com/profile/06491876959467764686noreply@blogger.com0tag:blogger.com,1999:blog-472913772483906208.post-9299412313540130302008-08-12T23:23:00.000-07:002008-08-12T22:19:29.148-07:00Show directionsHi,<br /><br />In a previous post, we saw how to do an "Hello World" using the <span style="font-weight: bold;">addMarker</span> procedure. Usually when someone needs a map on his website it's because he wants to show the location of some events. Adding directions to your map can help the users to locate and go to the events your are promoting. I am going to show you how to put a route with directions on your map using the <span style="font-weight: bold;">addDirection</span> procedure.<br /><br />I will assume you read the previous post and you know how to do a simple "Hello World".<br /><br /><span style="font-weight: bold;">1) PL/SQL Region - PLGMAPS code</span><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_eGo1vRawUKs/SKJrByUCsEI/AAAAAAAAAK8/Wf20niwcJbw/s1600-h/code.jpg"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://2.bp.blogspot.com/_eGo1vRawUKs/SKJrByUCsEI/AAAAAAAAAK8/Wf20niwcJbw/s200/code.jpg" alt="" id="BLOGGER_PHOTO_ID_5233863395387813954" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="font-weight: bold;">2) Example</span><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_eGo1vRawUKs/SKJrae5MVpI/AAAAAAAAALE/p2X6Z0sGtBY/s1600-h/example.jpg"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://2.bp.blogspot.com/_eGo1vRawUKs/SKJrae5MVpI/AAAAAAAAALE/p2X6Z0sGtBY/s200/example.jpg" alt="" id="BLOGGER_PHOTO_ID_5233863819671656082" border="0" /></a>Louis-Guillaumehttp://www.blogger.com/profile/06491876959467764686noreply@blogger.com0tag:blogger.com,1999:blog-472913772483906208.post-81622664256328019022008-07-28T20:05:00.000-07:002008-08-12T21:35:07.142-07:00Hello worldHi,<br /><br />This is the first example of PLGMAPS. It will demonstrate how to integrate an "Hello World map" into an Oracle Application Express (APEX) application. You don't need to understand JavaScript or the Google Maps API to add maps to your APEX applications.<br /><br />I take into consideration that you have read the following white paper of Oracle.<br /><a href="http://www.oracle.com/technology/products/database/application_express/pdf/Integrating_Application_Express_with_Google_Maps.pdf">Integrating Oracle Application Express with Google Maps</a><br /><br /><span style="font-weight: bold;">1) Create a Substitution String to store your Google Maps API Key value.</span><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_eGo1vRawUKs/SJHSmjOsutI/AAAAAAAAAKE/0anRy0ezn28/s1600-h/app_attributes_substitution_string.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://2.bp.blogspot.com/_eGo1vRawUKs/SJHSmjOsutI/AAAAAAAAAKE/0anRy0ezn28/s200/app_attributes_substitution_string.JPG" alt="" id="BLOGGER_PHOTO_ID_5229192202087611090" border="0" /></a><br /><br /><br /><br /><br /><span style="font-weight: bold;">2) 3 things to add on the Hello World Map page</span><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_eGo1vRawUKs/SJHSm1rjdbI/AAAAAAAAAKM/xfgja-pKcYQ/s1600-h/page_rendering.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://2.bp.blogspot.com/_eGo1vRawUKs/SJHSm1rjdbI/AAAAAAAAAKM/xfgja-pKcYQ/s200/page_rendering.JPG" alt="" id="BLOGGER_PHOTO_ID_5229192207040476594" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="font-weight: bold;">3) Page attributes - HTML body attribute</span><br />This code will load/unload the map. For more technical information, read the "reducing browser memory leaks" from the <a href="http://code.google.com/apis/maps/documentation/">Google Map API Concepts documentation</a>.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_eGo1vRawUKs/SJHSm-8TOQI/AAAAAAAAAKU/OdgXj0Hz7-Q/s1600-h/page_attributes_HTML_body_attribute.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://2.bp.blogspot.com/_eGo1vRawUKs/SJHSm-8TOQI/AAAAAAAAAKU/OdgXj0Hz7-Q/s200/page_attributes_HTML_body_attribute.JPG" alt="" id="BLOGGER_PHOTO_ID_5229192209526634754" border="0" /></a><br /><br /><br /><br /><br /><br /><span style="font-weight: bold;">4) PL/SQL Region - PLGMAPS code</span><br />This is where you will add the calls to PLGMAPS package to generate the JavaScript code.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_eGo1vRawUKs/SJHXtRfeZjI/AAAAAAAAAKs/2yOQqhuqDX8/s1600-h/plsql_region_plgmaps.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://3.bp.blogspot.com/_eGo1vRawUKs/SJHXtRfeZjI/AAAAAAAAAKs/2yOQqhuqDX8/s200/plsql_region_plgmaps.JPG" alt="" id="BLOGGER_PHOTO_ID_5229197815143360050" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_eGo1vRawUKs/SJHSnG1IDfI/AAAAAAAAAKc/SXIV13jEu_U/s1600-h/plsql_region_plgmaps_code.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://4.bp.blogspot.com/_eGo1vRawUKs/SJHSnG1IDfI/AAAAAAAAAKc/SXIV13jEu_U/s200/plsql_region_plgmaps_code.JPG" alt="" id="BLOGGER_PHOTO_ID_5229192211644026354" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="font-weight: bold;">5) HTML Region - Hello World Map</span><br />This is where you set the width and height of your map.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_eGo1vRawUKs/SJHSnTQoWAI/AAAAAAAAAKk/P1XlHsns93Q/s1600-h/html_region_helloworld_map.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://1.bp.blogspot.com/_eGo1vRawUKs/SJHSnTQoWAI/AAAAAAAAAKk/P1XlHsns93Q/s200/html_region_helloworld_map.JPG" alt="" id="BLOGGER_PHOTO_ID_5229192214980614146" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="font-weight: bold;">6) Example</span><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_eGo1vRawUKs/SJHYkd9s5HI/AAAAAAAAAK0/tszCR9fHFjI/s1600-h/Hello_World_Map.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://1.bp.blogspot.com/_eGo1vRawUKs/SJHYkd9s5HI/AAAAAAAAAK0/tszCR9fHFjI/s200/Hello_World_Map.JPG" alt="" id="BLOGGER_PHOTO_ID_5229198763384169586" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Wow! That was easy... more advanced features to come ;)Louis-Guillaumehttp://www.blogger.com/profile/06491876959467764686noreply@blogger.com0tag:blogger.com,1999:blog-472913772483906208.post-6066324628753180182008-07-28T19:45:00.000-07:002008-08-12T21:22:36.685-07:00Kick OffHi,<br /><br />During the past few weeks, I was testing many Google's services. My favorite, the Google Maps is the one that attract and retain my attention. I like the idea of maps in web applications for displaying locations, events, contacts, people, etc.<br /><br />I read an Oracle White Paper of March 2008 called <a href="http://www.oracle.com/technology/products/database/application_express/pdf/Integrating_Application_Express_with_Google_Maps.pdf">Integrating Oracle Application Express with Google Maps</a>. After giving it a try, I decided to dynamically build the map using PL/SQL. The usage of the <a href="http://code.google.com/apis/maps/documentation/reference.html">JavaScript API used by Google Maps</a> requires knowledge of Oriented Object Programming and might be a show stopper for some developers.<br /><br />I decided to build a PL/SQL package that can generate the JavaScript code needed to add Google Maps to your web applications.<br /><br />I plan to release a version for the public in the future, when there's enough functionality and documentation.<br /><br />To stay updated come back. :)Louis-Guillaumehttp://www.blogger.com/profile/06491876959467764686noreply@blogger.com0