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

Would this produce the desired result?

The PL/SQL procedure/function uses dbms_output.put_line calls to "load" the rows into the output buffer, each field separated by some separator. Additionally, it could set an output argument specifying how many rows are in the buffer. The client app then calls dbms_output.get_line to retrieve the rows.

Dave Podnar
NCR Corp.
dave.podnar_at_daytonoh.ncr.com

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.
  Received on Tue Aug 27 1996 - 00:00:00 CEST