Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I use NEXTVAL in stored procedure??

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

From: AAngel2 <aangel2_at_aol.com>
Date: 8 Dec 1998 23:40:15 GMT
Message-ID: <19981208184015.01092.00002415@ng-fi1.aol.com>

Try this...

Select your_seq.NEXTVAL
into v_your_id
from dual;

Embed this. Received on Tue Dec 08 1998 - 17:40:15 CST

This message: [ Message body ]
Next message: AAngel2: "Re: Learning Oracle"
Previous message: Daniel Fluet: "HELP with Error ORA-03113"
In reply to: Dan Gibbons: "How can I use NEXTVAL in stored procedure??"
Next in thread: victor: "Re: How can I use NEXTVAL in stored procedure??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US