What is the equivalent of Oracle's REF CURSOR in Postgresql when using JDBC?

Question

In Oracle I can declare a reference cursor...

TYPE t_spool IS REF CURSOR RETURN spool%ROWTYPE;

...and use it to pass a cursor as the return value...

FUNCTION end_spool
    RETURN t_spool
    AS
    v_spool t_spool;
    BEGIN
        COMMIT;
        OPEN v_spool FOR
            SELECT
                *
            FROM
                spool
            WHERE
                key = g_spool_key
            ORDER BY
                seq;
        RETURN v_spool;
    END end_spool;

...and then capture it as a result set using JDBC...

private Connection conn;
private CallableStatement stmt;
private OracleResultSet rset;
[...clip...]
stmt = conn.prepareCall("{ ? = call " + call + "}");
stmt.registerOutParameter(1, OracleTypes.CURSOR);
stmt.execute();
rset = (OracleResultSet)stmt.getObject(1);

What is the equivalent in Postgresql?

Arthur Thomas · Accepted Answer · 2008-09-17 21:37:50Z

4

Maybe this will help: http://jdbc.postgresql.org/documentation/83/callproc.html#callproc-resultset-setof

I haven't really messed with that before :P

answered Sep 17, 2008 at 21:37

Arthur Thomas

5,1871 gold badge29 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What is the equivalent of Oracle's REF CURSOR in Postgresql when using JDBC?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related