Re: How can I use NEXTVAL in stored procedure??

Dan Gibbons <Daniel.Gibbons_at_Sebank.co.uk> wrote in article <74ivo0$pg31_at_pound.sebank.se>...
> Hi,
>
>
> 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.

select GLMT_LOG_SEQ.NEXTVAL
into pLOG_ID
from dual Received on Tue Dec 08 1998 - 05:24:11 CST