Hi,
I need to update a specific value in an Oracle database. However, I'm running into trouble when trying to execute an SQL Update statement using the SQLExecutor. The very same statement works like a charm when executed in SQLDeveloper. The statement :
FME_SQL_DELIMITER ;
update table_a set valeur = 'New_Value'
where id in (
select av.id
from table_a av
join other a on a.id = av.idother and a.libelle = 'PARTNER A'
join table_p p on p.id = av.idproject and p.CODE = 'xxx'
);
When I execute this from FME, he connects to Oracle, but never finishes. The log get stuck at this moment :
Oracle database version is '11.2.0.1.0'
Environment variable ORACLE_HOME is not set.
Connecting to ORACLE database `ORCL' with user name of `TESTL' and password of `***'
Connected to ORACLE database `ORCL'
I've tried to put the SQL in one single line without success. I've also set the environment variable ORACLE_HOME without succes (although I'm not 100% i did it correctly even though the log told me the varible was set).
I use several SQLExecutors in the workspace to execute different Select statement and they all work. However, when trying to update a value... I'm not sure where to look next. Any ideas would be glady appreciated.