Re: How to (MyVariable := MySequence.currval)

Greg wrote:

> Need to save the current value of a sequence in a variable to use it
> later.
>
> declare
> MyVariable number;
>
> MyVariable := MySequence.currval;
>
> does not work

Hi,
you may need
1) select my_seq.nextval into :my_var from dual -- if you ar the owner of my_seq
2) grant [Alter,] Select on owner.my_seq TO [Role | user] 3) alias or select owner.my_seq.nextval into :my_var from dual; H.F. Received on Wed Jun 28 2000 - 00:00:00 CEST