Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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>...Received on Sun May 19 2002 - 14:49:52 CDT
>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?
>