Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |