Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.linkpendium.com!border1.nntp.sjc.giganews.com!border2.nntp.sjc.giganews.com!nntp.giganews.com!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail
Date: Fri, 30 Apr 2004 19:40:49 +1000
From: "Howard J. Rogers" <hjr@dizwell.com>
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Startup Trigger Can't Do DDL ...
References: <c7e08a19.0404291359.45aed24@posting.google.com> <40918f69$0$14771$afc38c87@news.optusnet.com.au> <c6t489$j3h$1@news.BelWue.DE>
In-Reply-To: <c6t489$j3h$1@news.BelWue.DE>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 33
Message-ID: <40921f1a$0$20085$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 203.164.5.122
X-Trace: 1083318043  20085 203.164.5.122
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260475

Holger Baer wrote:

> Howard J. Rogers wrote:
> 
>>
>> And never mind the loss of numbers when an instance crashes: what 
>> about the loss of numbers that will happen when somebody rolls back 
>> their transaction (or suffers a blue screen of death in 
>> mid-transaction and has PMON roll it back for them)? Or when the 
>> junior DBA wanting to know what the last sequence number issued was 
>> happens to select from currval?
>>
> 
> Just curious (or lazy if you wan't, because I didn't dig into the
> documentation just now): What do you think that happens?
> Selecting from currval returns the last retrieved number for the *CURRENT*
> session - if it had never been retreived you get an
> 
> select sequencename.currval from dual;
> 
> ORA-08002: sequence <sequencename> is not yet defined in this session
> 
> 
> This is what a quick test on 10g confirmed.
> 
> Regards,
> 
> Holger

It's true for 9i, too. Dunno, really.

Regards
HJR