returning cursors/resultsets to client programs using Oracle stored procedur

From: Edmund Landgraf <>
Date: Fri, 28 May 1999 11:28:25 -0700
Message-ID: <7imn72$srg$>


We're trying to get a resultset back into JDBC using Openlink and encountering a peculiarity with Oracle that doesn't allow you do to a 'SELECT' to return a snapshot of your data. Instead, you must use an OUT variable which to my understanding must be scalar (i.e. JDBC doesn't support returning a cursor)

What is the preferred way of doing, say, a "select ename from emp" and getting your calling program (say, java, VB, whatever) to iterate through the result set and print out the results?

-Ed Landgraf Received on Fri May 28 1999 - 20:28:25 CEST

Original text of this message