7.11 SDO_NFE.DROP_MODEL_SEQUENCE

Format

SDO_NFE.DROP_MODEL_SEQUENCE(
     model_id  IN NUMBER,
     seq_name  IN VARCHAR2);

Description

Drops a sequence along with its relationship with the specified NFE model.

Parameters

model_id

ID of the NFE model.

seq_name

Name of the sequence.

Usage Notes

The relationship of the sequence with the model is deleted from the table registered in SEQUENCE_REG_TAB from the xxx_SDO_NFE_MODEL_METADATA views.

Examples

The following example deletes the sequence named PIPES_FTLAY_ID_SEQ from the NFE model with the ID 1.

EXECUTE SDO_NFE.DROP_MODEL_SEQUENCE(1, 'PIPES_FTLAY_ID_SEQ');