select myseq.currval from dual;
or
insert into myTable.... returning myId into myval;
See returning in the docs.
Jim
"Bryon Lape" <aintnoway_at_noway.com> wrote in message
news:3CE060D0.714A7521_at_noway.com...
> I have an ATG Dynamo 4.5 app running on top of Oracle 8i. I have a
> trigger that gets the next number of a sequence and puts the value in an
> id column upon row insert (no autogenerated ids in 8i as far as I can
> find). I would really like to get the id that was used in the sequence
> after the insert. The only column guaranteed to be unique is the id.
> Can either Oracle or Dynamo return this value?
>
Received on Mon May 13 2002 - 20:38:07 CDT
