Read Oracle Sequence Nextval and use in Counter

Article Number: 000001142 - Last Modified: Jul 8, 2011

You want to use the nextval in an Oracle Sequence as the start count in a Counter transformer.

You can use either SQLCreator or Creator + SQLExecutor transformers. Add the appropriate SQL, i.e. SELECT test_seq.nextval from DUAL. You can add AttributeExposer to make the return Oracle value accessible as an attribute in workbench.

Suggested Similar Articles

Get the "Start Count" for the Counter from a different dataset

You are reading a dataset and want to assign unique id's to the features in this dataset using a Counter transformer. However, the starting value for the Counter is stored in a different ...

Using Feature Counters in an FME workspace

Feature Counters are the (optional) display of the number of features that have passed through a connection within an FME workspace.

Using FME to read or write Comma Separated Value (CSV) data

FME can be used to read or write non-spatial formats such as CSV files and translate them into other non-spatial formats

Counter

The Counter is a Workbench transformer that adds an incrementing numeric value to each incoming feature.

What's Great 2011

"What's Great" is a summary list of all the new and updated functionality in a particular version of FME. This is the list for FME Desktop 2011.

Table Of Contents

Suggested Similar Articles