7.21 SDO_NFE.GET_NEXT_SEQUENCE_VALUE

Format

SDO_NFE.GET_NEXT_SEQUENCE_VALUE(
     sequence_name        IN VARCHAR2,
     seq_value_increment  IN NUMBER
     ) RETURN NUMBER;

Description

Returns the value resulting from adding the value of the second parameter to the current value of the specified sequence.

Parameters

sequence_name

Name of the sequence.

seq_value_increment

Integer value to be added to the current value of sequence_name. (If the specified value is negative, it is subtracted from the current value.)

Usage Notes

This function does not change the INCREMENT BY value of the specified sequence or the current value of that sequence.

This function can be used to manage a block of consecutive sequence numbers.

Examples

The following example returns the value that would result from adding 10 to the current value of a sequence named MY_SEQ.

SELECT SDO_NFE.GET_NEXT_SEQUENCE_VALUE('my_seq', 10) FROM DUAL;

If the current value of MY_SEQ is 100, this example returns the value 110 (100 + 10).