Re: New to Oracle 7/triggers

From: Tina Morgan <Tina.M.Morgan_at_bridge.bellsouth.com>
Date: 1996/01/08
Message-ID: <30F1A8C4.776D_at_bridge.bellsouth.com>#1/1


Try declaring a variable as NUMBER (say new_variable). Then, "select equipment_seq.nextval into new_variable from dual;" Then your assignment statement would be :new.equipment_id := new_variable; I'm not sure why it doesn't work the way you have it, but this works. Received on Mon Jan 08 1996 - 00:00:00 CET

Original text of this message