Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: get id after insert

Re: get id after insert

From: Vyacheslav Soldatov <sslava_at_cbank.kz>
Date: Wed, 22 Dec 1999 10:36:09 +0600
Message-ID: <83pkdb$lq$1@mail.nursat.net>


>1. In n-user environment, how would anyone know that the record THEY just
>inserted was the
>last one inserted into the table?

How I understood, the problem is in reseiving the current value of id after insert not last value...
Every user has his own session and that method (which uses pakage) will return only current user's id value after insert.

The point 2 is the same. Your temp variable of "insert_a_value" function perfectly can be a value of id just inserted (using suggested method, but your not have to bind temp in your insert statment). May be there are some another things, but this method works also... Received on Tue Dec 21 1999 - 22:36:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US