Re: SQL Server to Oracle question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 2 Sep 2000 00:20:20 +0200
Message-ID: <967847261.18406.2.pluto.d4ee154e@news.demon.nl>

I answer this question multiple times per week, and the deja-archives should be flooding with my responses.

You need to use a REF CURSOR. Either look that up in your documentation, or refer to
http://osi.oracle.com/~tkyte and go to resultsets.

Hth,

Sybrand Bakker, Oracle DBA

<dannenbring_at_mnr.org> wrote in message news:8oom66$tuk$1_at_nnrp1.deja.com...
> I've been using SQL Server for a number of years and now have to
> convert to Oracle. I've written a number of stored procedures that
> will populate a local temporary based on various calculations. At the
> end of the stored procedure I perform a 'select *' to return all of the
> rows. In Oracle you can only return one row of data. I'm wondering
> what suggestions people my have on the best way to immitate this in
> Oracle.
>
> Thanks,
>
> Mike
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 01 2000 - 17:20:20 CDT