The next query results in an error (ORA-00900: Invalid SQL-statement.)
FME_SQL_DELIMITER /
begin
update tbx.ext_compare_person
set gesnam_d = tbx.diakriet_cip(gesnam_d,sourcekey,'GNAAM')
, gesvor = tbx.diakriet_cip(gesvor,sourcekey,'VNAAM')
, gesnam_d_p = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GNAAM_P')
where organisatiecode = 'ABDC'
and applicatiecode = 'ABC';
end;
/
commit;
/
+22FME_SQL_DELIMITER is used to indicate the character that is going to separate one SQL sentence from another.
Usually is ";".
I'm not sure what you are doing with the '/' character.
More info here: https://knowledge.safe.com/articles/516/splitting-sql-statements-using-the-fme-sql-delimit.html
Hi Oscard,
Thank you for your answer.
I need the SQL Executor to update several columns in Oracle based on a function (diakriet_cip). First I tried this:
FME_SQL_DELIMITER ;
update tbx.ext_compare_person
set gesnam_d = tbx.diakriet_cip(gesnam_d,sourcekey,'GNAAM')
, gesvor = tbx.diakriet_cip(gesvor,sourcekey,'VNAAM')
, gesnam_d_p = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GNAAM_P')
where organisatiecode = 'ABDC'
and applicatiecode = 'ABC';
commit;Hi Oscard,
Thank you for your answer.
I need the SQL Executor to update several columns in Oracle based on a function (diakriet_cip). First I tried this:
FME_SQL_DELIMITER ;
update tbx.ext_compare_person
set gesnam_d = tbx.diakriet_cip(gesnam_d,sourcekey,'GNAAM')
, gesvor = tbx.diakriet_cip(gesvor,sourcekey,'VNAAM')
, gesnam_d_p = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GNAAM_P')
where organisatiecode = 'ABDC'
and applicatiecode = 'ABC';
commit;
FME_SQL_DELIMITER /
update tbx.ext_compare_person
set gesnam_d = tbx.diakriet_cip(gesnam_d,sourcekey,'GNAAM'),
gesvor = tbx.diakriet_cip(gesvor,sourcekey,'VNAAM'),
gesnam_d_p = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GNAAM_P')
where organisatiecode = 'ABDC'
and applicatiecode = 'ABC';
commit;
/Source: https://knowledge.safe.com/questions/66481/sqlexecutor-atomic-transaction-by-commit.html
+60Hi Oscard,
Thank you for your answer.
I need the SQL Executor to update several columns in Oracle based on a function (diakriet_cip). First I tried this:
FME_SQL_DELIMITER ;
update tbx.ext_compare_person
set gesnam_d = tbx.diakriet_cip(gesnam_d,sourcekey,'GNAAM')
, gesvor = tbx.diakriet_cip(gesvor,sourcekey,'VNAAM')
, gesnam_d_p = tbx.diakriet_cip(gesnam_d_partner,sourcekey,'GNAAM_P')
where organisatiecode = 'ABDC'
and applicatiecode = 'ABC';
commit;
+22
+60
FME_SQL_DELIMITER /
DECLARE
i number := 0;
BEGIN
update TABLE1
set COLUMN1 = 'testvalue';
i := sql%rowcount;
END;
/
FME_SQL_DELIMITER /
DECLARE
i number := 0;
BEGIN
update TABLE1
set COLUMN1 = 'testvalue';
i := sql%rowcount;
update RESULT set RESULT = (i);
END;
/