Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieving the key of a newly inserted record
Galen Boyer <galenboyer_at_hotpop.com> wrote in
news:u7ke4zczb.fsf_at_standardandpoors.com:
> On insert use seq_name.nextval then in same session you can ask
> for seq_name.currval.
Wow, that was pretty fast. If I understand you correctly, I have to retrieve the seq-name.currval value within my stored procedure?
A thousand thanks, this sounds good to me.
Regards, Claus. Received on Fri Dec 20 2002 - 14:11:02 CST