Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • Is it possible to increment a sequence with another value in Oracle writer in FME workspace?

Here I am trying to get the sequence before writing data into oracle. All I need to do is to start this sequence with the value of 5000000000.

As we can use this in insert function - "insert into nb (XFM_ID) values(XFM_ID_SEQ.NEXTVAL + 5000000000)"

But this is not working in FME. I tried all possible ways to insert sequence starting from 5000000000 like using sql creator,executor etc.

Sequenced Table columns does not accept " XFM_ID:XFM_ID_SEQ.NEXTVAL+5000000000"

I generated sequence from SQL Executor using command -'select xfm_id_see.nextval+1000000000 from dual'. Features were given to SQL Executor as initiator input where sequence was added as a new column in result output. Then I passed these results to Oracle Spatial Object Writer without assigning any sequence in Advanced parameter. It added sequence into db as I wanted.

Reply


Community Stats

30,112
Posts
114,303
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.