problem assignment with sequence

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 Fri Apr 16 1999 - 05:27:55 CDT