Re: HELP: Attempting to use Before Triggers and Sequences to auto-generate Primary Keys

Lee:

After declaring iCounter, try this:

SELECT test_seq.NEXTVAL into iCounter FROM dual;  :new.ID := iCounter;

instead of what you have:

> :new.Id := Test_SEQ.NEXTVAL;

Also, qualify the sequence name with its owner if appropriate.

Tim Romano
Swarthmore PA Received on Sat Jun 14 1997 - 00:00:00 CDT