Re: Return ROWID in Java

"Massimo" <massimo.visman_at_tin.it> writes:

> String query = "INSERT INTO emp (ename) VALUES ('Massimo')";
> PreparedStatement pstm = myConnection.prepareStatement("declare x
> number; begin ? returning emp_id INTO x; dbms_output.put_line(x);
> END;"); pstm.setString(1, query); resultSet = pstm.executeQuery();
>
> but it doesn't work at all! :(

Try to use the Callablestatement. This for example works for me.

,----

| String sql =
|     "begin insert into seq (id) values (seq_seq.nextval) " +
|     "returning id into ?; end;";
| CallableStatement stmt = Sql.get(con,sql);
| stmt.registerOutParameter(1,Types.INTEGER);
| stmt.executeUpdate();

Harald Received on Wed Feb 18 2004 - 02:23:17 CST