How do I get a result set back from a stored procedure? I was
expecting something like this:

CREATE PROCEDURE readIdentity( oid INTEGER ) AS
BEGIN
SELECT * FROM Objects WHERE identity=:oid;
END

Then, in JDBC:

CallableStatement st = con.prepareCall( "{call readIdentity(?)}" );
ResultSet rs = st.executeQuery();

I guess I am expecting it to be too easy. But I haven't found any
documentation on this.

TIA,

Robert