Re: problem assignment with sequence

oracle does not treat sequences as "variables". it treats it as "columns".
so you "have to" select their values.

Vadim wrote:

> on Oracle 8.0.4 server
>
> create sequence schema1.sequence1;
> ...
> create table1 (...,field1 number unique);
> ...
>
> create or replace trigger schema1.trigger1;
> before insert on schema1.table1 for each row
> begin
> :new.field1 := schema1.sequence1.nextval; -- error!
> end;
>
> Does anyone know why this does not work?
>
> But this working :
>
> create or replace trigger schema1.trigger1;
> before insert on schema1.table1 for each row
> begin
> select schema1.sequence1.nextval into :new.field1 from dual; -- working!
> end;
>
> But this contain three operation: nextval,select and assignment;
>
> first example - only two: nextval and assignment.
>
> please help
>
> Answers send to: vadim_at_kpvti.kiev.ua
> Thanks
> Vadim Grigoryev
Received on Mon Apr 19 1999 - 08:34:08 CDT