What I would like to focus on this topic is one of the most important features: Oracle Forms 11g is JavaScript enabled! This new functionality makes it possible to execute JavaScript in the page in which the Forms applet is embedded.
JavaScript can be used to integrate Forms with any application that provides a JavaScript API, or simply with custom HTML/ADF pages that embed JavaScript functionality.
Oracle FMW MapViewer currently provides 2 JavaScript APIs (the newer one supports HTML 5) for incorporating highly interactive maps and spatial analysis. The integration with Oracle Forms is done via one of these JavaScript APIs.
What would an integrated application look like? Let’s suppose you’re a company with multiple offices that provide different services based on the location and office type. Displaying that info in an HTML table doesn’t look very appealing to the customers, while they get lost in the tons of information.
Why not displaying all the office locations on a map? When a customer clicks on a location, an information window provides all necessary information at the first glance. May be also a thumbnail of an image representing the office, as well as a link to a web resource giving even more information.
How is this done?
First, make sure you have an Oracle Database 11g (11.2.0.3 minimum) with Oracle Spatial or at least Oracle Multimedia (which includes Oracle Locator) installed.
Then, you need to have Oracle Forms 11g and install Oracle FMW MapViewer on top of it. Download MapViewer from here and then install the Mapviewer.ear according to the documentation.
Oracle FMW MapViewer comes with a demo application called MVDEMO (please note that this web resource is not assured to be available 24x7) which is a great way to get you started! After importing the MVDEMO sample data into your database, deploy MVDEMO.war onto a WebLogic Server and configure the data source in the MapViewer Administration Console:
<map_data_source name="mvdemo" jdbc_host="<YOUR DB HOST>" jdbc_sid ="<DB SID>" jdbc_port="<DB PORT>" jdbc_user="mvdemo" jdbc_password="!mvdemo" jdbc_mode="thin" number_of_mappers="3" allow_jdbc_theme_based_foi="false" editable="false" />
[formsmapviewer] baseHTMLjpi=jsmap.html userid=dbuser/dbpass@host:port/SID form=formsmapviewer.fmx width=320 height=763 # Config for javascript integration applet_name=formsmapviewer_applet enableJavascriptEvent=true JavaScriptBlocksHeartBeat=true splashScreen=no guiMode=3 lookAndFeel=Oracle colorScheme=blue
This is how we display the map, centering it at Oracle Munich office:
function showMap() { mapview = new MVMapView(document.getElementById("map"), baseURL); mapview.addMapTileLayer(osmBasemap); //Oracle Munich office var mpoint = MVSdoGeometry.createPoint(11.56, 48.13, 8307); mapview.setCenterAndZoomLevel(mpoint,7); mapview.addNavigationPanel() ; mapview.display(); mapview.addCopyRightNote("&2014 Powered by Oracle ©2010 GfK GeoMarketing"); mapview.addNavigationPanel("EAST"); mapview.addScaleBar(); }
<div id="map" style="left:0px; top:0px; width:1250; height:763"></div>
web.javascript_eval_expression('zoomIn();');
web.javascript_eval_expression('createFOI('||:CONTROL.LONG||','||:CONTROL.LAT||', 8307);');
http://formshost:formsport/forms/frmservlet?config=formsmapviewer
- Zoom in, zoom out from both map and the Forms application
- Pan up, down, left, right from both map (navigation panel) and the Forms application
- Overview map on the right bottom corner with the possibility to move the map
- Scale bar on the left bottom corner of the map
- Copyright note on the right bottom corner
- Features of Interest:
- When hitting "Create FOI" button an image is created on the map at the longitude and latitude coordinates specified as parameters. When clicking the image an Information Window with Oracle is opened and you can navigate to the webpage
- Hit Remove FOI to delete the feature of interest (needs the id of the FOI)
- Alternatively, you can create other FOIs by specifying different coordinates
- Custom themes: (In Germany appear when selecting the checkboxes "On mouse over" the airports or highways, you'll see their name.)
- Airports and
- Highways
Feel free to try it out and enhance your Forms application with a nice map.
14 comments:
Thanks for Information Oracle Online Training Oracle is an object-relational database management system created and marketed by Oracle Corporation.Oracle Online Training
It was really a nice article and i was really impressed by reading this article We are also giving all software Course Online Training.The oracle Online Training is one of the leading Online Training institute in the world.
interesting piece of information, I had come to know about your web-page from my friend pramod, jaipur,i have read atleast eight posts of yours by now, and let me tell you, your blog gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a million once again, Regards, obiee training in hyderabad
Any chance I can get a copy of the formsmapviewer.fmx form mentioned in this blog? Would be most appreciative.
interesting article. But please help to get fprmsmapviewer.fmx . The link above doesnt work. Waiting for response. Thanks.
Amazing Article, thank you!. I am very glad to read your informative & practical blog. Kindly keep updating your blog.
Java Developer is a wonderful career for IT students.To start Dream Career to become a Java developer learn from
Java Training in Chennai. or learn thru Java Online Training from India .
Woah this blog is wonderful i like studying your posts. Keep up the great work! You understand, lots of persons are hunting around for this info, you could help them greatly.
python training in chennai
python course institute in chennai
Its really an Excellent post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog. Thanks for sharing....
Data Science training in rajaji nagar
Data Science with Python training in chennai
Data Science training in electronic city
Data Science training in USA
Data science training in pune
Really you have done great job,There are may person searching about that now they will find enough resources by your post
Best Devops online Training
Online DevOps Certification Course - Gangboard
Such a great word which you use in your article and article is amazing knowledge. thank you for sharing it.
DevOps Training | Certification in Chennai | DevOps Training | Certification in anna nagar | DevOps Training | Certification in omr | DevOps Training | Certification in porur | DevOps Training | Certification in tambaram | DevOps Training | Certification in velachery
Wow!! such a great information.Thank you for sharing with us. Java training in Chennai | Certification | Online Training Course | Java training in Bangalore | Certification | Online Training Course | Java training in Hyderabad | Certification | Online Training Course | Java Training in Coimbatore | Certification | Online Training Course | Java Training in Online | Certification | Online Training Course
Wow, amazing post! Really engaging, thank you.
Tableau Training in Pune
Best Tableau Training Institute in Pune
gate
binance
coinbase mi binance mi
bitcoin
binance referans kimliği nedir
kripto para nasıl alınır
coin nasıl alınır
binance 20
tiktok jeton hilesi
Come up with a great learning experience of Azure training in Chennai, from Infycle Technologies, the best software training institute in Chennai. Get up with other technical courses like Data Science, Selenium Automation Testing, Mobile App Development, Cyber Security, Big Data, Full Stack Development with a great learning experience and outstanding placements in top IT firms. For best offers with learning, reach us on +91-7504633633, +91-7502633633.
Post a Comment