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