Procedure fo a new sequence value

Hi,

How to create procedure that returns a new sequence value. As an Oracle newbie I've tried this:

CREATE SEQUENCE VOLGNUMR
  START WITH 1
  INCREMENT BY 1
  NOCYCLE
  CACHE 20
  NOORDER; CREATE procedure NewVolgNumr( NewKey out number ) is begin

   NewKey := volgnumr.nextval;
end;

but that does'nt work. Any Ideas?

Thanks in advance

Jaap. Received on Wed Mar 03 1999 - 15:16:55 CST