Re: Getting ResultSet using JDBC when calling Stored-Procedures

Check out http://fts.postgresql.org/db/mw/msg.html?mid=1354157 from the
mail archives.

--Barry

Arthur & Kathy Yeo wrote:
>
> -----Original Message-----
> From: Arthur & Kathy Yeo [mailto:ayeo(at)acm(dot)org]
> Sent: Monday, June 10, 2002 8:25 PM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: Getting ResultSet using JDBC when calling Stored-Procedures
>
>
> In reading the docs for PL/pgSQL, I noticed that there is no mention about
> PL/SQL-TABLES which in Oracle allows stored procedures to do a SELECT and
> return all the rows thru one of its OUT arguments.
>
> Some people suggested that we can get the stored procedure to return a
> CURSOR and the caller can access that cursor thru JDBC. The only method I
> saw related to cursor in JDBC is getCursorName().
> Anyone know how to access a returned CURSOR coming back from a
> stored-procedure at the JDBC interface?
>
> Similar needs in doing a bulk INSERTs thru a stored procedure.
>
> --
> Arthur
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>