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.
+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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.