How to get the returning value through JDBC [message #366622] |
Fri, 17 March 2000 02:18 |
Andy Kam
Messages: 1 Registered: March 2000
|
Junior Member |
|
|
I would like to execute an insert statement (to a table without a key) and also get the rowid immediately.
For PL/SQL
declare
o_rowid rowid;
begin
INSERT INTO TEST1 (ACNO, PASSWORD) VALUES ('0001', 'ANDY1') returning rowid into o_rowid;
dbms_output.put_line('ROWID : '||o_rowid);
end;
I find it impossible to use getResultSet() to get back the returning rowid. Is it possible to get it through JDBC ?
Thanks a lot.
|
|
|