Re: returning cursors/resultsets to client programs using Oracle stored procedures

From: Reid Lai <reidlai_at_pacific.net.hk>
Date: Sun, 30 May 1999 20:27:25 +0800
Message-ID: <37512EAD.7C178ADC@pacific.net.hk>

How about using DBMS_SQL?

Edmund Landgraf wrote:

> 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

--
Best Regards,

Reid Lai
Oracle 7.3 Certified DBA (OCP)

---

e-mail : mailto://reidlai@pacific.net.hk homepage : http://www.pacific.net.hk/~reidlai

---

• The above opinions are mine and do not
• represent any official standpoints of my
• employer or third parties.

Received on Sun May 30 1999 - 07:27:25 CDT