We have the following job design:
[oracle oci stage] --> [oracle oci stage]
We configured UPSERT with user defined statement in order to do an insert only.
If source and target are the same dbms (ora 9i) upsert works.
If source is different from target (9i dbms A --> 9i dbms B) upsert fails stating:
Message:
Oracle_Enterprise_19: The provided update statement did not prepare correctly;
please verify that your statement is correct;
statement: insert into test (spalte_a) values('foobar').
No more details on why the statement did not prepare correctly
However, using the job's db-credentials connecting to the target (e.g. with sqlplus), the statement works perfectly.
