Re: Calling a sequence in a stored program unit
From: <brendan_o'brien_at_wrightexpress.com>
Date: Fri, 15 May 1998 20:28:16 GMT
Message-ID: <6ji8h0$46e$1_at_nnrp1.dejanews.com>
Date: Fri, 15 May 1998 20:28:16 GMT
Message-ID: <6ji8h0$46e$1_at_nnrp1.dejanews.com>
SELECT rejet_seq.nextval INTO num_enreg FROM dual;
That will do it.
Good Luck,
-Brendan
In article <6jgnk0$3dh$1_at_platane.wanadoo.fr>,
"Christophe" <perinfo_at_wanadoo.fr> wrote:
>
> Hello.
> I have a PLS-00357 error when i want to create a stored program unit on this
> line:
> NUM_ENREG := REJET_SEQ.NextVal;
> The sequence REJET_SEQ has been created by:
> create sequence rejet_seq start with 1;
> Thanks for sending to me a solution at: lsa.perinfo_at_wanadoo.fr.
>
>
[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 15 1998 - 22:28:16 CEST