Skip to main content
  • EN

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.

Oracle Non-Spatial Reader Parameters (safe.com)

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.

SQLExecutor_oracleDear @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


Community Stats

30,196
Posts
114,615
Replies
37,859
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.