I'm trying to use the DatabaseJoiner transformer to link to an Oracle Spatial view (not table), but the SDO column is not appearing, nor is the geometry showing up in the resulting joined features. Can this transformer be used for this purpose?
Page 1 / 1
It is possible that you'll have to manually add the spatial view metadata in the "user_sdo_geom_metadata" table, e.g.:
insert into user_sdo_geom_metadata
using select 'RT43495_VIEW', column_name, diminfo, srid
from all_sdo_geom_metadata
where owner = 'DEV' and table_name = 'RT43495';See also this article for more information: https://knowledge.safe.com/articles/782/adding-metadata-entries-for-oracle-spatial-tables.html
It is possible that you'll have to manually add the spatial view metadata in the "user_sdo_geom_metadata" table, e.g.:
insert into user_sdo_geom_metadata
using select 'RT43495_VIEW', column_name, diminfo, srid
from all_sdo_geom_metadata
where owner = 'DEV' and table_name = 'RT43495';See also this article for more information: https://knowledge.safe.com/articles/782/adding-metadata-entries-for-oracle-spatial-tables.html