Thanks, Mike, The detailed log was useful.
Because of multiple geometry types stored in a single table I already had a selection in my DATA line: DATA 'GEOMETRY FROM (select c.GEOMETRY from [table] c where c.GEOMETRY.GET_GTYPE()=3) ... My problem was solved when I inserted 'c.RGBCOLOR, ' before c.GEOMETRY Márton 2011/12/17 Smith, Michael ERDC-CRREL-NH <[email protected]> > Márton, > > You can use DEBUG mode (DEBUG 3 or higher on the LAYER) to see in your > error log the exact query that MapServer is generating. The fact that you > are seeing an ORA-00904 for RGBCOLOR as an invalid identifier indicates > that the column request is being passed to Oracle but that your column in > your table must have a different name. > > You also don't specify your version. > > I have tested this on MapServer 6 and an Oracle Spatial connection and > not had any issue. > > Mike > > -- > Michael Smith > US Army Corps > Remote Sensing GIS/Center > From: Forián-Szabó Márton <[email protected]> > Date: Sat, 17 Dec 2011 21:45:04 +0100 > To: <[email protected]> > Subject: [mapserver-users] Color values from attribute using OracleSpatial > > Hi, > my problem when using attributes for color values with OracleSpatial: > RGB color values are defined as a string like '0 128 211' in a column > named 'RGBCOLOR'. > The map file looks like > ... > STYLE > COLOR [RGBCOLOR] > ... > Trying this with Shape+dbf files the coloring of the shapes works > properly, but when the data is in OracleSpatial and I reference to the > 'RGBCOLOR' column in the same way I receive: > OracleSpatial error. Error: ORA-00904: "RGBCOLOR": invalid identifier > > Thanks for any suggestions! > > Márton Forián-Szabó > _______________________________________________ mapserver-users mailing > list [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
