I am trying to update a value in an Oracle database connected using RJDBC (the connectionis fine as I can query the database from within R). I tried the following (and many variants of it):
dbSendUpdate(db_iot, "UPDATE IOT_DATA SET IOTFILE = (?) WHERE VARIABLE = (?);", "1_prod_vorl_0.Rmd", 'wss')
In Oracle Developer I can run the query like this without any problems:
UPDATE IOT_DATA SET IOTFILE = '1_prod_vorl_0.Rmd' WHERE VARIABLE = 'wss';
Any help would be appreciated.
Cheers
Renger