Question

Update an Oracle table from an Oracle table VIEW...is it possible and how to set it up, please?

  • 30 July 2021
  • 1 reply
  • 0 views

I have an FME process that updates one Oracle table from another via a ChanageDetector process. I notified the DBA that the table I am reading from is missing a field. The DBA created a able VIEW with the missing field and advised I use that to update the other table.  I don't see Oracle table VIEWS as an option in the Reader I am using. Can an Oracle table VIEW be used in a Reader? If so, how is that accomplished?

Thanks in advance.


1 reply

Userlevel 3
Badge +33

Are you reading a spatial view? Then the metadata of the view needs to be defined in MDSYS.SDO_GEOM_METADATA. See here for more info.

Reply