Tom
I have a table with a auto-incrementing id. From time to time I want to insert rows to this table, but want to be able to know what the pk of the newly inserted row is. One way I could do this is:

SQL> variable var1 number;

SQL> insert into test (name) values ('test value') returning id into :var1;
1 row created.

SQL> print var1;
13

How can I now do the same thing in jdbc?

Just to give you an idea, here's what I've been trying to do: As best as I can write it, that in java should be:

String query = "insert into test (name) values ('test') returning id into :var1";
OracleCallableStatement cs = (OracleCallableStatement) conn.prepareCall(query);
cs.registerOutParameter(1, OracleTypes.NUMBER );
cs.execute();
System.out.println(cs.getInt(1));

The problem is that when I run it, I get an error: java.sql.SQLException: Protocol violation

Another thing I've tried is doing the same thing but in a procedure:
ie: declare pk number; begin execute immediate 'insert into test (name) values (''test'') returning id into :var1' using out pk; end;

No dice in that either.

Now I know I could do this in two transactions: first a select for the sequence.nextval then I can manually use that sequence as the primary key (and thus removing the trigger alltogether )

Something else I could do is simply wrap the whole thing in a stored procedure and then call the procedure... but that might end up being too much work to maintain (Ie changing a methdo would require me to edit the code and also the stored procedure)

I've seen in the forums people have been able to do this in ONE transaction in .net. Why Can't I do it JDBC?

Thanks, Achille