Re: Getting trigger value after insert

See the FAQ below for ideas.
Search for autonumber in the index

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Bryon Lape wrote in message <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?

>