Re: Non working sequence

What environment are you working in ?
The following is listing as executed from SQL*Plus (Oracle 8.0.5)

SQL> create table address (id number primary key);

Table created.

SQL> create sequence myseq;

Sequence created.

SQL> insert into address(id) values (myseq.nextval);

1 row created.

SQL> insert into address(id) values (myseq.nextval);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from address;

       ID

        1
        2

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Frank van Bortel wrote in message <380785AB.4037CBB4_at_vnl.nl>...
>> insert into adress(id) values(myseq.nextval);
>> insert into adress(id) values(myseq.nextval);
>>
>> ORA-00001: unique constraint (ROLAND.ADRESS_ID_PRIM) violated
>>
>> select id from adress;
>>
>> id
>> --
>> 0
>>
>> Q1: Why is id = 0?? myseq has a minimum of 1.
>> Q2: Why doesn't myseq.nextval update the number??
>>
>> When I created a dummy-table without the primary-key myseq works fine.
>> But not on the adress-table.
>>

>
>That's not the way sequences work. Select from them. Your other table
>should have
>the same problem, that is all values are 0.
>
>