Ray Godfrey wrote:
> 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.....
missing a slash after the "end;"
...
end;
/
Received on Mon Mar 08 2004 - 11:25:34 CST
