Skip to main content

Hi,

I need to reproject feature coordinates (with ReframeReprojector) coming from an Oracle Spatial Object reader and therefore want to exclude feature types that are views from being reprojected.

Manuel

You can use the SQLExecutor transformer to get information from the TAB table in the Oracle database (Select tabtype from TAB where TNAME = '@Value(fme_feature_type)'). This will show if the fetaure type is a VIEW or TABLE.


Optionally you can just filter out the views if the information can be found in feature type (e.i using V or VW for view in the feature type name) eventually try avoiding reading the views if the naming is consistent by using the Feature Type To Read parameter.

Hope this helps.


Reply