Using Oracle ROWID as an Update key
Posted: Thu Jun 12, 2008 7:40 am
We are trying to use the Oracle ROWID pseudo column as the update key in an Oracle Enterprise Stage. The job does a lookup on the table which returns the ROWID of the matching record (if one exists).
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.
ORA-01745: invalid host/bind variable name
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
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