[mapserver-dev] Oracle Spatial and CLOB columns

[bartvde at osgis.nl]

Hi list,

currently, when a table contains a CLOB column, queries on it through
Mapserver will fail with:

msOracleSpatialLayerGetShape(): OracleSpatial error. Error: ORA-00932:
inconsistent datatypes: expected %s got %s

Ofcourse one can overcome this by not using this column in the subselect
(DATA statement) or creating a database view, but it is a bit cumbersome
and hard to maintain.

Is there not a way that the Mapserver Oracle Spatial driver just ignores
CLOB columns?

I've tried to implement this but was unsuccessfull.

Mapserver gets the columns with

sprintf( query_str, "SELECT * FROM %s", table_name );

and OCI_DESCRIBE_ONLY which makes sure the query does not get executed.

I tried to use something like:

sprintf(query_str, "select column_name from user_tab_columns where
table_name = '%s' and (NOT DATA_TYPE = 'CLOB')", table_name );

but could not adapt the rest of the code to use this.

Maybe there is another way though.

Best regards,
Bart