Re: Returning a record set with a stored procedure

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 21 Nov 2001 15:33:39 GMT
Message-ID: <nPPK7.53693$XJ4.32194742@news1.sttln1.wa.home.com>

Search NG for ref cursor.
Jim
"Russ McTyre" <rmctyre_at_hotmail.com> wrote in message news:5a6ed0d7.0111210517.666e056f_at_posting.google.com...
> I would like to create a simple stored procedure that consists of a
> single SELECT statement. Can you do this with Oracle? If so, can
> someone give me a hint on the syntax?
>
> Example:
>
> Table_A
> -------
> ProductId
> ProductDescription
>
> SELECT ProductId, ProductDescription
> FROM Table_A
Received on Wed Nov 21 2001 - 09:33:39 CST