We added ROWID to the column list of the Oracle stage, which is set as an Upsert with an Auto-Generated Update. ROWID is the only key column.
Code: Select all
Update (abridged):
T_EARNINGS_SNAPSHOT_update: Update prepare failed:
update is: UPDATE T_1 SET F_1 = :F_1, ... , WHERE (ROWID = :ROWID)
It seems as thought ROWID is an invalid bind variable name. We have change the name of the column linked to ROWID in the preceding Transformer, but no luck.
Is there a workaround to enable using ROWID as the update key in Oracle?
Thanks