Re: Mapping PL/SQL tables to VB tables

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Fri, 20 Jul 2001 10:00:50 -0700
Message-ID: <3B5863C2.BA5B2AF6@attws.com>

"Joni Pinomäki" wrote:

> When I get data from oracle database it's from PL/SQL tables. And output
> parameters are sort of one dimensional table which are each one datatype
> (like varchar, number,...).
>
> Do anyone know, whether it is possible to map a parameter like those to such
> a particular array in VB, and if so, how?
>
> Joni

As you posted no code and identified no Oracle version it is hard to tell what it is you are doing. But to return multiple rows to VB from Oracle I would suggest you explore using refcursors.

Daniel A. Morgan Received on Fri Jul 20 2001 - 12:00:50 CDT