Dale,

Thanks for taking the time to respond.

Try this symbol definition. I vaguely remember having this issue and I used 
this symbol to fix it.

'SYMBOL(a:0,c:#ff0000,s:6pt,id:"mapinfo-sym-34.ogr-sym-4")'

so

create or replace view vw_australian_cities
as
select rownum as rid,
        a.abbr as abbreviation,
        a.city_name,
        a.geom.Get_WKB() as geom,
        CAST('SYMBOL(a:0,c:#ff0000,s:6pt,id:"mapinfo-sym-34.ogr-sym-4")' as 
varchar2(255)) as OGR_STYLE
   from australian_cities a;

I tried this but it didn't work. I also tried putting a comma ',' instead of a 
full stop '.'  between the mapinfo-sym34 and ogr-sym-4 but that didn't work 
either.

If you can remember more clearly what you did to get it work I would appreciate 
it.

regards
SImon
--
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL 
Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius 
Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
  Email: [email protected]
  Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to