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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
