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.
Oracle 10g issue
Moderators: chulett, rschirm, roy
So... two different posts with the same issue?
viewtopic.php?t=122860
That way leads to madness, or at least schizophrenic discussions.
viewtopic.php?t=122860
That way leads to madness, or at least schizophrenic discussions.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Sorry about that - but I didn't realize that my colleque had already posted that issue. I will mark this post as solved.chulett wrote:So... two different posts with the same issue?
viewtopic.php?t=122860
That way leads to madness, or at least schizophrenic discussions.