Home » Developer & Programmer » JDeveloper, Java & XML » How to get the returning value through JDBC
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.
Previous Topic: Help!!!
Next Topic: Retrieving a Long Raw Column
Goto Forum:
  


Current Time: Sat Jul 24 15:16:48 CDT 2021