ref cursor is the datatype you want, and yes it is possible.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"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
>
>
Received on Fri May 02 2003 - 15:18:50 CDT
