Ivan,

> > > I might be at the tail end of the thread, but what's wrong with an
> > SP that
> > > returns the ID. We do it all the time...
> >
> > There is nothing wrong with that approach. But it has one
> > disadvantage: Maintaining!
>
> Because generators are not tied to any particular field,
> you can have single generator (and SP to retrieve it) for whole database.

but with the suggested approach you still have to have one SP for each
table, which makes the whole thing difficult to maintain.
Personally I prefer to fetch the value in advance and use it for the
insert statement (as has been suggested).
Ciao
--
____
_/\/ando