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 -> Retrieving ROWID during INSERT in JDBC?

Retrieving ROWID during INSERT in JDBC?

From: Walker Boh <walkerboh_at_nospam.shymail.com>
Date: Sun, 06 Jan 2002 00:46:36 GMT
Message-ID: <Xns918DB485767F2walkerbohshymailcom@204.127.202.16>

Is it possible to retrieve the ROWID of a newly inserted row during the INSERT operation using JDBC?

I saw an example on the Oracle docs using PL/SQL and a syntax similar to the following (inside a procedure):

INSERT INTO table VALUES( x, y ) RETURNING ROWID INTO rID

But I haven't been able to make this work from within JDBC. Any ideas?

I'm using 8i (8.1.7) and 9i and JDK 1.2. Received on Sat Jan 05 2002 - 18:46:36 CST

Original text of this message

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