Skip to main content
Solved

Is it possible to increment a sequence with another value in Oracle writer in FME workspace?

  • February 18, 2020
  • 1 reply
  • 95 views
G

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"

Best answer by gauripearl

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

G
  • gauripearl
  • Author
  • Best Answer
  • February 21, 2020

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.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.