returning cursors/resultsets to client programs using Oracle stored procedures

All,

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?

Thanks,
-Ed Landgraf Received on Fri May 28 1999 - 13:31:36 CDT