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