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

From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/08/25
Message-ID: <4vpuud$qlt_at_client3.news.psi.net>#1/1


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 Sun Aug 25 1996 - 00:00:00 CEST

Original text of this message