Re: Result Set as Return Value ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 2 May 2003 22:16:54 +0200
Message-ID: <vb5kt8hv6lk8bc@corp.supernews.com>

"Georg Scholz" <georg.scholz_at_vienna.at> wrote in message news:h2Asa.149868$v62.1523596_at_news.chello.at...
> Dear all,
>
> is it prossible to write a stored procedure which returns the result set
of
> a SELECT - Statement?
>
> Just looked through the manuals and found datatyes "RECORD" or
"DATASET". -
> Can these be used for this purpose?
>
> Thanks in advance
>
> Georg Scholz
> www.scholz-informatik.at
>
>

This question has been asked
over and over
and over and over
and over and over
and over and over
and over and over
and over and over
again

Look in your manual for REF CURSOR

and PLEASE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

search google BEFORE posting, to avoid BOOOOOOOOOORING questions like this one.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Fri May 02 2003 - 15:16:54 CDT