| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Triggers & Sequences
Benjamin Davies wrote:
> DECLARE
> new_id NUMBER;
> BEGIN
> SELECT obj_id_seq.nextval INTO :new_id FROM dual;
As I read your example you must code :new.obj_id = new_id. But better
would be
BEGIN
SELECT obj_id_seq.nextval INTO :new.obj_id FROM dual;
Helmut
www.bitoek.uni-bayreuth.de Received on Mon Feb 16 1998 - 00:00:00 CST
 |
 |