Mailing-List: contact user-help@struts.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Struts Users Mailing List" <user@struts.apache.org>
Received-SPF: pass (hermes.apache.org: domain of asamere@rochester.rr.com
 designates 24.24.2.56 as permitted sender)
Message-ID: <450AD3EA.3000507@rochester.rr.com>
Date: Fri, 15 Sep 2006 12:25:14 -0400
From: Adam J Samere <asamere@rochester.rr.com>
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
To: Struts Users Mailing List <user@struts.apache.org>
Subject: Re: Out of topic, Oracle SEQUENCE
References: <82701c100609150917k6d1e9e4dpc222723689f7cd5a@mail.gmail.com>
In-Reply-To: <82701c100609150917k6d1e9e4dpc222723689f7cd5a@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Use curval to obtain the last selected value for the current oracle 
session. Note that you cannot access curval until nextval has been used 
at least once in the current oracle session.

select user_seq.curval
from dual

Daniel Chac�n S�nchez wrote:
> Hi I know this the struts mail list, but I have a question and I hope 
> that
> someone know the answer
>
> I'm using an oracle database, I have a sequence to obtain the nextval 
> that
> will be the key of the row that I will insert, after the insert I need to
> know which is that value so I can tell the user with which value the 
> row was
> inserted. Is there a sure fire way to do this, or am I stuck with "select
> max(id) from table" and hope nothing else has been inserted in that few
> milliseconds it takes to go from my insert statement to my select 
> statement?
>
> Some code, for better explanation:
>
>
> CREATE SEQUENCE user_seq INCREMENT 1 MINVALUE 0 NOMAXVALUE  START WITH
> 0  NOCACHE
> NOCYCLE
>
>
>
> insert into users values (user_seq .nextval, 'userName');
>
>
>
> Then I need to know the value with which the row was inserted, how can 
> I do
> that
>
>
> Thanks! Sorry fot the out of topic question
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org