I can not access views in my oracle DB neither with the oracle non-spatial reader nor with a SQLExecutor.
Is there a workaround?
The FME Help also talks uniquely about tables, never views.
Question
Oracle: Connect to a View
+10- Safer
Hi @hodelc
Oracle spatial and non-spatial table list is based on the entries from the SDO_GEOM_METADATA table. Typically VIEWS are not included in this table so it will not show up in the Table list.
If you know the name of the view, you should be able to manually type the VIEW name in the table list.
Dear @rahulsharma
I have already tried exactly that. If I write a select SELECT * from a known view, i get no cached values. This is odd, since i can populate the row names from the view with the SQL statement.