Re: How do I retrive newly added records?

Hi,

I think You should use a SEQUENCE to solve Your problem. For a sequence named SEQ You have to change the insert statement to:

statement.executeUpdate ("INSERT INTO mytable VALUES (SEQ.NEXTVAL, myvalue1, myvalue2,...)");

and You have to use SEQ.CURRVAL instead of the 0 for all other occurances.

You can creat the SEQENCE with the following statement: CREATE SEQUENCE SEQ; The user who insert the rows needs the select privilege on the SEQUENCE or the SELECT ANY SEQUENCE privilege.

I hope that I can help You

Fredrik Öhrn wrote:

> Hello!
>
> I'm working on a java applet that adds records to an Oracle database.
>
> To add a new record I use the following construct:
> statement.executeUpdate ("INSERT INTO mytable VALUES (0, myvalue1, myvalue2,
> ...)");
>
> The catch is that the first 0 is a primary key column and the server
> automatically assigns a unique running number instead of the value I provide.
> How can I get hold of the server assigned primary key value? I need it to add
> records to other tables that has this key as a foreign key.
>
> Any input is appreciated.
>
> Regards,
> Fredrik
>
> --
>
> I don't see why there's a problem with computers thinking
> it's the year 1900. Computers weren't even invented in 1900.
>
> Fredrik Öhrn Chalmers University of Technology
> d96ohrn_at_ios.chalmers.se Sweden

--
Best Regards,

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.