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
+17- Contributor
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.
+16- Supporter
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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.