DSXchange

DS-EE 7.5.3, Oracle 10g environment, HP-UX on Intel Ithanium


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.

So... two different posts with the same issue?

viewtopic.php?t=122860

That way leads to madness, or at least schizophrenic discussions.

chulett wrote:So... two different posts with the same issue?

viewtopic.php?t=122860

That way leads to madness, or at least schizophrenic discussions.

Sorry about that - but I didn't realize that my colleque had already posted that issue. I will mark this post as solved.