Can you return a cursor from a RDB Stored Procedure. If so can
someone give me a example of the implementation.

Thanks in advance
ShamanSC

I am not sure if this is possible or not (I work in a different area of
the product). contact your Oracle Rdb support group and they should be
able to quickly help you out. Alternately, join JCC's Rdb list server
(www.jcc.com for more information) and try asking there.

ShamanSC wrote:

Hi,

This can't be done in the same way as other DBMSs (eg: SQL Server) do it
but you may be able to use Global Temporary Tables with Rdb to achieve the
same thing. That is, populate/manipulate the rows in the temporary table
during the stored procedure, thereby making them available to the caller of
the procedure when it exits.

Regards Richard Maher.

PS. I've never doene this but it should work :-)

ShamanSC <garyfry (AT) scnet (DOT) com> wrote