Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Howto put a sequence in a variable.

Howto put a sequence in a variable.

From: Dirk Joosen <d.joosen_at_REMOVETHIS.planetinternet.nl>
Date: Wed, 17 Nov 1999 17:45:20 +0100
Message-ID: <3832DBA0.82D76159@REMOVETHIS.planetinternet.nl>


Hello

Is it possible to get the value of a sequence and to write these to an variable. I could be something like
l_id NUMBER;
l_id : = SEQUENCE.NEXTVAL;

This is not allowd but is there a possibility to make this work??? Regards and thanks Dirk Received on Wed Nov 17 1999 - 10:45:20 CST

Original text of this message

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