This content has been marked as final. Show 2 replies
You can use Oracle ADF for integrate Oracle MapViewer and Geospatial data in DB and ADF had tools for selection elements in maps
You can see this post: https://blogs.oracle.com/shay/entry/working_with_the_adf_dvt
Since the stored redline info is in the db already you just need a predefined theme defined on it.
Then add that theme (MVThemeBasedFOI) to the map.
The Oracle Maps tutorial has examples of this. The "Theme Based FOI" layer example which displays the customers theme.
In your case it'll be a redlines theme which display areas/polygons instead of points.