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

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...

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.
*----------------------------------------------------*