Re: A simple question, I hope

It sounds like you need to look at the 'returning' clause:

insert into tableX values ...
returning ID into {local variable}

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Darryl wrote in message ...


>How do I get the trigger-generated ID number for the row I just added to a

>table?  I can't do a SELECT MAX(ID) because it's a high transaction system.

>

>Thanks,

>Darryl

>

>