Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Returning a ResultSet from a stored procedure

Returning a ResultSet from a stored procedure

From: Alex A. <albu_at_mailcity.com>
Date: Tue, 28 Sep 1999 22:28:37 GMT
Message-ID: <7srfe9$tch$1@nnrp1.deja.com> 





Hi.



Is there a way to return a ResultSet from a stored procedure/function?
The only way I know of (in Oracle) is to have the stored function return
a reference to a cursor (REF CURSOR) and the Java client register the
return type as OracleTypes.CURSOR which can then be casted to a
ResultSet. But this uses Oracle specific stuff in the client. Is there
another way to do it?




TIA



Alex




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Tue Sep 28 1999 - 17:28:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US