Skip to main content
Question

problem updating in oracle


Forum|alt.badge.img

Hi Folks I have a question of a customer. He tried a very simple manipulation : Updating a data in a Oracle Non spatial writer, by adding a column, but do not succeed. In the writer, there is the column information, that has to contain fiels to be updated. But we don't find where encoding the key field ...

 

In old versions, there was a line indicating clearly, the key field of the table, to match. ANy idea or truck ?

2 replies

david_r
Celebrity
  • June 7, 2019

If you mean to try and add a column to an existing table in Oracle, then that isn't possible with an FME writer.

It's possible, however, to modify table defintions with SQL, so you can either do it with a SQLExecutor or with a 3rd party tool like SQLDeveloper or Toad.


david_r
Celebrity
  • June 7, 2019

If you simply need to update a table based on an existing column, here's an example based on the primary key column "MY_PK":

Alternatively you can use the DatabaseUpdater transformer, some people find the setup there more intuitive.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings