One Star

[resolved] Unable to exclude Additional Columns in tOracleOutput update

Is there anyway to exclude the Additional Column in an update using tOracleOutput?
I am generating an additional column key using an Oracle sequence.
However after noticing some updates were failing I noticed that the generated update statement was trying to update the "additional column" (see below). Is there any way to exclude the additional column when using field options?
1 ACCEPTED SOLUTION

Accepted Solutions
Employee

Re: [resolved] Unable to exclude Additional Columns in tOracleOutput update

Try adding the column to the schema. Then in the Additional columns section select the new column as the Reference and set the position to replace.
4 REPLIES
One Star

Re: [resolved] Unable to exclude Additional Columns in tOracleOutput update

*bump*
Employee

Re: [resolved] Unable to exclude Additional Columns in tOracleOutput update

Customers component image:
Employee

Re: [resolved] Unable to exclude Additional Columns in tOracleOutput update

Try adding the column to the schema. Then in the Additional columns section select the new column as the Reference and set the position to replace.
One Star

Re: [resolved] Unable to exclude Additional Columns in tOracleOutput update

Thanks that works!