Re: Calling a sequence in a stored program unit
From: skv <skv_at_kpbank.ru>
Date: Fri, 15 May 1998 14:56:35 +0800
Message-ID: <6jgomv$n8t$1_at_home.kpbank.ru>
Date: Fri, 15 May 1998 14:56:35 +0800
Message-ID: <6jgomv$n8t$1_at_home.kpbank.ru>
Christophe пишет в сообщении <6jgnk0$3dh$1_at_platane.wanadoo.fr> ...
>Hello.
>I have a PLS-00357 error when i want to create a stored program unit on
this
>line:
> NUM_ENREG := REJET_SEQ.NextVal;
Hi Christophe
Pseudocolumns NEXTVAL and CURRVAL are available only in DML statements.
Try
SELECT rejet_seq.NEXTVAL INTO num_enreg
FROM DUAL
It will be works
Regards
Konstantin V. Sartakov Kuzbassprombank Kemerovo Russia mailto:skv_at_kpbank.ruReceived on Fri May 15 1998 - 08:56:35 CEST