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

From: <Kelvin>
Date: 1996/11/02
Message-ID: <55dd10$gb1_at_svdns1.ubinet.ubs.com>#1/1


I'm familiar with passign PL/SQL tables around between server based packages and also passing a PL/SQL table down to 3GL code (as in your example), but ...
how to you pass this table or many tables to say a VB GUI client who has accessed the database using ODBC.

regards
Kelvin

tkyte_at_us.oracle.com (Thomas J. Kyte) wrote:

>PL/SQL can return pl/sql tables (like arrays) to clients. Additionally, pl/sql
>can open a cursor that a 3gl fetches from as such (the following example, for
>7.2 and up, demonstrates how to open a cursor in pl/sql that depends on the
>inputs):

...snip

>Thomas Kyte
>Oracle Government
>tkyte_at_us.oracle.com
>
Received on Sat Nov 02 1996 - 00:00:00 CET

Original text of this message