• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » keep oracle sequence value in Output data

#1 2009-03-17 19:06:06

fpc01
Member
Registered: 2008-05-19
Posts: 17

keep oracle sequence value in Output data

My job need to insert data in an Oracle table using an Oracle Sequence.
I saw I have to use advenced setting Additionnals columns to use mysequence.nexval(), to increment it.
It is OK, I have a clean ID column.

I would like to keep this value on my flow, to use it later.

When using main link On tOracleOutput component, to print it with a tLogrow,
ID column value is null on console, but is good in oracle Table.

I want to create my id, using oracle sequance nexval, and then add it to my data.


Uploaded Images

Offline

#2 2009-03-18 14:47:02

fpc01
Member
Registered: 2008-05-19
Posts: 17

Re: keep oracle sequence value in Output data

I found a solution :
use a tOraclerow to execute nexval query,  using Propagate QUERY's recordset option,
and a tParseRecordSet.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » keep oracle sequence value in Output data

Board footer

Powered by FluxBB