How to: Retrieve Sequence.NEXTVAL into a variable

Does anyone know how to retrieve the next value (or current value) a sequence into a variable in a stored procedure. I have tried various things including:-

function x
(

...

)
return ...
is

    MyVar integer
begin

    select MySequence.nextVal into MyVar;
...

end;

But have had no luck getting anything to work.

Thanks in advance
hugh. Received on Fri Nov 13 1998 - 05:55:43 CST