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
Hi Shong,
I followed the example and still getting an error.
Do I need to define this column in tMap somehow? Or is the only thing I need to do is define it in additional columns in tOracleOutput?
In additional columns, after "Before", whic column do I put in as reference column?
I am stuck in my development project, and your help would be greatly appreciated.
Thanks,
Boris
I am stuck in my development project, and your help would be greatly appreciated.
What's your error message? You don't show me what's wrong, it is a simple question but I can' t help you without any info about your job!!! I think you should upload some screenshots of your job, so I could know what are doing and what you are doing wrong,
Best regards
shong
Just to clarify here's exactly what I did in tOracleOutput:
I have a column invoice_interface_id, and i need to insert an Oracle sequence into it.
In advanced columns I specify:
name: "invoice_interface_id"
SQL expression:"vrtx.vrtx_lexnex_ap_invoices_int_s.nextval"
Position: Before
Reference column: invoice_interface_id
in tMap, I created a column: invoice_interface_id, and left Expression as blank.
If I remove invoice_interface_id column from tMap, in tOracleOutput, Reference_column invoice_interface_id disappears from the option window.
What do I need to do?
You don't need define invoice_interface_id column on tMap, remove it.
In advanced columns specify:
name: "invoice_interface_id"
SQL expression:"vrtx.vrtx_lexnex_ap_invoices_int_s.nextval"
Position: Before
Reference column: the column after invoice_interface_id in your real table(for example, there are three columns in your table:
invoice_interface_id,name,age
the reference column is name here)
You don't need define invoice_interface_id column on tMap, remove it. In advanced columns specify: name: "invoice_interface_id" SQL expression:"vrtx.vrtx_lexnex_ap_invoices_int_s.nextval" Position: Before Reference column: the column after invoice_interface_id in your real table(for example, there are three columns in your table: invoice_interface_id,name,age the reference column is name here)
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.
