Re: How get the current value from a sequence?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 30 Nov 2004 20:30:09 -0000
Message-ID: <41acd83e$0$19160$cc9e4d1f@news-text.dial.pipex.com>

"Ubiquitous" <weberm_at_polaris.net> wrote in message news:cohkou$son$1_at_news.utelfla.com...
> 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?

roles aren't enabled for PL/SQL. The owner of the SP needs the appropriate rights granted on the underlying object.
>
>>whats wrong with select seq_name.nextval fom dual?
>
> I don't want to gaps in the sequence.

Then use a method that serializes on a table. Sequences guarantee uniqueness not completeness.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Tue Nov 30 2004 - 14:30:09 CST