Re: How get the current value from a sequence?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 30 Nov 2004 08:12:06 -0800
Message-ID: <1101831029.559641@yasure>

Ubiquitous wrote:

> In article <%RLqd.25958$up1.3264_at_text.news.blueyonder.co.uk>, x_at_x.com says...
>
>

>>need to be dba to read that view

>
>
> Does running a stored procedure change one's role?
>
>

>>whats wrong with select seq_name.nextval fom dual? 

>
>
> I don't want to gaps in the sequence.

Then don't use a sequence. Also don't ever perform deletes.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Nov 30 2004 - 10:12:06 CST