Re: Seqence Number in Triggers Please Help

>CREATE OR REPLACE TRIGGER TR_ANDY_TEST
> BEFORE INSERT ON TB_ANDY_TEST
>  FOR EACH ROW
>   BEGIN
>     :NEW.DT= DT_SEQ.NEXTVAL
>   END;
>/

Try another code, like:
...
BEGIN
    select DT_SEQ.NEXTVAL into :NEW.DT from DUAL; END; Sincerely yours

    Edward

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 10 1998 - 00:00:00 CST