Hi Jukka, You really did the most difficult part :
{ import com.vividsolutions.jts.geom.*; import com.vividsolutions.jump.feature.*; import com.vividsolutions.jump.geom.EnvelopeUtil; import com.vividsolutions.jump.workbench.model.*; htmlFrame = wc.workbench.frame.outputFrame; htmlFrame.createNewDocument(); htmlFrame.setTitle("BBOX Output"); fc = wc.getLayerNamePanel().getSelectedLayers()[0].getFeatureCollectionWrapper(); for (Iterator i = fc.getFeatures().iterator(); i.hasNext();) { Feature feature = (Feature) i.next(); Geometry geometry = feature.getGeometry(); Envelope env = geometry.getEnvelopeInternal(); htmlFrame.addText("SELECT * \n" +"FROM ORACLE_TABLE ot \n" +"WHERE sdo_anyinteract (ot.geoloc,SDO_GEOMETRY('" + geometry +"',SRID))='TRUE';" ); } wc.workbench.frame.flash(htmlFrame); htmlFrame.surface(); } ------------------------------------------------------------------------------ Android apps run on BlackBerry 10 Introducing the new BlackBerry 10.2.1 Runtime for Android apps. Now with support for Jelly Bean, Bluetooth, Mapview and more. Get your Android app in front of a whole new audience. Start now. http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel