Hi,
I am trying to insert a bunch of columns into an Oracle table from tMap, along with an oracle sequence.
I have the following process:
tFileInputDelimited connected to tMap component connected to tOracleOutput.
In tMap, I mapped out all the columns from the delimited file.
In tOracleOutput, I went into Advanced Settings, and defined an Oracle sequence giving it a name and an sql expression:
vrtx_lexnex_ap_invoices_int_s.nextval, and specified the refence column that I want the sequence to be inserted into.
I am getting an error on tOracleOutput (Component Error).
Do I need to do something in tMap, so that tOutputOracle knows about the sequence name.
Please let me know,
Thanks,
Boris
If i select the toracleoutput action on data to Insert or Update, it throws an error stating it requires Key. If i want to do insert or update how do i do it.
For update action, you need to set one column as key on the schema of tOracleOutput.
Best regards
Shong
For update action, you need to set one column as key on the schema of tOracleOutput. Best regards Shong
Hi Shong,
I have a question related to this topic and need the answer. If my target table uses the sequence numbers generated by Oracle Sequence as a primary key, how to accomplish insert/update on tOracleOutput?
Did you mean I should use an alternate key on the schema of tOracleOutput to do insert/update?
