How can I use NEXTVAL in stored procedure??

Hi,

I've just started to use Oracle and I'm trying to assign NEXTVAL to a variable in a strored procedure which I then want to use in an insert statement and return the new number via an output parameter. When I try and save the stored procedure I get "Can't use sequence in this context". This is the offending line:-

pLOG_ID := GLMT_LOG_SEQ.NEXTVAL;

Does anyone know how I can create a stored procedure that will assign NEXTVAL to a tables ID field and return the ID that it used?

Thanks in advance.

Dan Received on Tue Dec 08 1998 - 04:38:19 CST