7.3 SDO_NFE.CREATE_MODEL_SEQUENCE

Format

SDO_NFE.CREATE_MODEL_SEQUENCE(
     model_id      IN NUMBER,
     owner_name    IN VARCHAR2,
     aequence_name IN VARCHAR2);

Description

Creates and registers a sequence for a model.

Parameters

model_id

ID of the NFE model.

owner_name

Sequence's related table.

aequence_name

Name of the sequence to be created.

Usage Notes

All the sequences for the base tables are created by the SDO_NFE.CREATE_MODEL_STRUCTURE function, but you may need to create other sequences (such as for features).

The NFE model and the sequence’s related table must exist.

Examples

The following example creates a sequence for the NFE model identified by the ID 1 and a table named FEATURES.

SDO_NFE.CREATE_MODEL_SEQUENCE(’1’,’features’,’features_seq’)