I think it will be returned as an 'out' parameter. If this is true it will
require you to use the registerOutParameter method to register before
executing the SQL and then getInt() On the statement after executing the
statement. This may require a CallableStatement, which is why it doesn't
quite sound right.
I do what you are asking via a stored procedure call, using an out parameter
and a callable statement as described above.
You can just check the JDBC docs for Oracle. They are available on their
website.
Cheers
-----Original Message-----
From: Dennis Djenfer [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 7:51 PM
To: [EMAIL PROTECTED]
Subject: Primary Key Generation
Hi all,
One way to generate a primary key, insert a new row and retrieve the
generated key in one call is to use the following SQL sentence (at leat
in a Oracle database)
INSERT INTO emp VALUES (empseq.nextval, 'LEWIS', 'CLARK') RETURNING id
INTO :bnd1
How do I read the binding variable (:bnd1) that contains my primary key
(from column "id") from java? Will the binding variable be presented in
the resultset like:
primaryKey = rs.getInt(bnd1)
or how do I get the value from the Returning clause?
If somebody wonder why I don't test it myself it's because I don't have
access to a development environment right now
// Dennis
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
