Oracle Connector Stage error with "LOG ERRORS INTO"
Posted: Fri Sep 05, 2014 8:35 am
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.
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.