Dmitry Yemanov wrote:

>"
>
>>Virtually all of my application level programming is in Java, for
>>example, and JDBC has no way to support the construct above. [OK, I
>>suppose you could argue that it doesn't have a way to access a sequence,
>>either, which would rather put me on the spot].
>>
>>
>
>Since Java can process input and output params (e.g. EXEC PROC) correctly,
>it can process INSERT ... RETURNING as well. There's no difference here.
>
>
>
>

Not really. Updates are performed with java.sql.PreparedStatement. A
program can set values in PreparedStatement, but fetching values is done
through java.sql.ResultSet. The procedure execution mechanism uses a
refinement of PreparedStatement, java.sql.CallableStatement, which does
have provision to return a ResultSet.