Toad World® Forums

Sequence errors

Sql nav 7.1 and 6.7 are both showing the same behavior.

Test case

  1. Create a sequence in a schema.

create sequence schema_name.sequece_name_seq nocache;

(increment this sequence a few times so the value is not 1)

  1. Create a sequence with the same name in your own schema.

create sequence sequence_name_seq nocache; (should default into your own personal schema)

  1. select schema_name.sequence_name_seq.nextval from dual;

You will select the value of the sequence from your schema not the target schema.

Hi OracleDBA,

Thanks for your report this good defect, we have created a new story (SQLNAV-1822) for it, and we will foucs on it until it is fixed.

Thanks and regards.

Alan