Re: Can PL/SQL return a table-like result set to GUI clients?

On Mon, 26 Aug 1996 12:32:42 GMT, Roderick Prince <rrprince_at_comdisco.com> wrote:

>Dave Mausner wrote:
>>
>> In article <4voss6$q3s_at_crl.crl.com>, sbixby_at_crl.com (Steven W. Bixby) wrote:
>> >
>> >I've been messing around with PL/SQL for awhile now, doing mostly "fire
>> >and forget" calls that do not have results.
>> >
>> >One thing I haven't seen mention of is whether an Oracle stored procedure
>> >can return a result set that looks like a table to GUI front-ends.
>>
>> No, it cannot do that.
>>
>> >
>> >IE, when using Delphi or another client environment, can I execute a
>> >PL/SQL stored procedure and treat the results as a table, to be able to
>> >browse (presumably read-only...)?
>>
>> No, that is not possible with pl/sql thru oracle 7.3.x.
>>
>> --
>> Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.
>
>--
>
>Wow am I getting confused by all the mixed messages regarding this
>subject...
>
>Oracle documentation and tech support claims that this is possible via
>cursor variables. Trying to prove the claims via source code are
>proveing to be another story...
>

You can return result sets from stored procedures in one of two ways:

• in pl sql tables
• as cursors that are fetched from in the client.

Definitely, postively, absolutely true.

See my previous examples.

>I am beginning to believe that Dave is right and Oracle is trying to
>play politics because this feature is no problem in SQLServer.
>
>Happy trails,
>Roderick...
>
>*----------------------------------------------------*
>Roderick Prince Aerial Systems Group, Inc.
>These thoughts are my own, who else would want them.
>*----------------------------------------------------*

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com -- Check out our web site! Brand new, uses Oracle Web Server and Database

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Tue Aug 27 1996 - 00:00:00 CEST