If by client you are referring to something like MSAccess or a VB app, then
you will need to use Oracle Objects for OLE. It provides an Oracle Data
Control that properly communicates with a stored procedure which uses
cursors just as you suspected. Documentation supplied with Oracle Objects
gives proper syntax as do the examples.
--
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)
Haresh Assumal <assumal_at_sprynet.com> wrote in article
<01bcd262$e94e9300$fab1aacc_at_mycomp.intermediainc.com>...
> HI,
> Could someone please tell me how can I return mutliple rows from a stored
> procedure? I think I need to open a cursor, but how do I return the
results
> to the client?
> Any help would be much appreciated.
> Thanks,
> Haresh
> Email: assumal_at_sprynet.com
>
>
Received on Mon Oct 06 1997 - 00:00:00 CDT
