Question

problem updating in oracle


Badge

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

Userlevel 4

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.

Userlevel 4

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.

Reply