[resolved] Unable to exclude Additional Columns in tOracleOutput update

Two Stars

[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?

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.

All Replies
Two Stars

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.
Two Stars

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

Thanks that works!