i have found an example from this site
http://jen.fluxcapacitor.net/geek/autoincr.html
following their instructions i have applied it toward my own code and
successfully created the sequences
i have then tried to insert the relevent trigger but it keeps going to
the next line,
e.g
SQL> create trigger STUPROPTRIG before insert on STUPROJPROP for each
row begin select NEXTSTUPROP.n
extval into :new.STUPROP_ID from dual;
2 end;
3
4
i then tried it again and typed commit; hoping it would work,
any suggestions would be appriecated,
thanks,
your buddy, ;-)
Ray.....
Received on Mon Mar 08 2004 - 11:11:58 CST
