On Tue, Jun 12, 2001 at 02:08:13PM -0500,
"Sykora, Dale" <Dale.Sykora@COMPAQ.com> wrote:
> Erik,
> If your bar column has unique values, perhaps you could SELECT foo
> FROM foobar where bar='whatever'; after your insert. Or perhaps write a
> procedure that stores the currval into a variable named by user/session/etc
> if this is possible.
currval is already tied to the current session. You can use it to refer
to the last serial value used in the current session.