Re: Returning a cursor/recordset etc from oracle stored procedure
From: Chet West <chetwest_at_carolina.rr.com>
Date: Wed, 21 Nov 2001 02:29:45 GMT
Message-ID: <tkEK7.25582$jr5.6654212_at_typhoon.southeast.rr.com>
Date: Wed, 21 Nov 2001 02:29:45 GMT
Message-ID: <tkEK7.25582$jr5.6654212_at_typhoon.southeast.rr.com>
Define a TYPE that looks like your record.
Define a PLSQL table using your TYPE.
Return the PLSQL table.
"Thomas Nyongesa" <tnyongesa_at_kc.rr.com> wrote in message
news:A1EK7.510815$ME2.64822703_at_typhoon.kc.rr.com...
> Hi folks,
>
> Does anyone know the most straightforward way to select and return columns
> from a table via a PL/SQL stored procedure? I am fairly new to PL/SQL
with
> a more extensive background in T-SQL.
>
> Thanks.
>
>
Received on Wed Nov 21 2001 - 03:29:45 CET