Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd7cy2so!shaw.ca!border1.nntp.ash.giganews.com!nntp.giganews.com!newsfeed.stueberl.de!fu-berlin.de!newsfeed.gazeta.pl!news.gazeta.pl!not-for-mail
From: krzys <krzys128@nospam_o2.pl>
Newsgroups: comp.databases.oracle.misc
Subject: sequence doesn't work ?
Date: Mon, 02 Feb 2004 14:45:09 +0100
Organization: Portal Gazeta.pl -> http://www.gazeta.pl
Lines: 33
Message-ID: <bvlk5g$p6o$1@inews.gazeta.pl>
NNTP-Posting-Host: 13-moo-5.acn.waw.pl
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: inews.gazeta.pl 1075729392 25816 62.121.92.13 (2 Feb 2004 13:43:12 GMT)
X-Complaints-To: usenet@agora.pl
NNTP-Posting-Date: Mon, 2 Feb 2004 13:43:12 +0000 (UTC)
X-Accept-Language: pl, en-us, en
X-User: krzys1825
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; PL; rv:1.5) Gecko/20031007
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:135252

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