Oracle Connector Stage error with "LOG ERRORS INTO"

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
abhik05
Participant
Posts: 28
Joined: Thu Mar 08, 2012 8:31 am

Oracle Connector Stage error with "LOG ERRORS INTO"

Post by abhik05 »

Hi
I am using Oracle connector stage to insert records into target database table.
I am using user defined insert statement only where I am trying to use "LOG ERRORS INTO" clause to insert rejected records in a different database table.But to do this I am getting errors as :
ORA-38909: DML Error logging is not supported with BATCH ERROR mode

I have tried ways like:
Created environment variable CC_ORA_DISABLE_BATCH_ERRORS from datastage administrator and set the variable value as 'TRUE'.
But the issue did not resolve.

I don't want to go with Enterprise stages.

Can anyone please help me to resolve this.

Regards
abhik.
Post Reply