Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: get id after insert
>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