sequence doesn't work ?

I haven't written any SQL code for 3 years. I thought it should be easy but ....

1. I creater new sequence:

create sequence counter;

2. Checked if everything is ok

select * from user_sequences

my new sequence was on the list

3. wanted to select current value of this sequence

select counter.currval from dual

but en error appears : ORA-08002: COUNTER.CURRVAL hasn't been defined in

ths session yet   ???????????????????

what does it mean ?

K.

-- 
Używam MozilliPL, a Ty? MozillaPL: http://www.MozillaPL.org