Re: VB - ODBC - PL/SQL TABLES?
From: John Thwaites <John.Thwaites_at_alliedsignal.com>
Date: 1998/03/11
Message-ID: <35070277.26A0_at_alliedsignal.com>#1/1
Date: 1998/03/11
Message-ID: <35070277.26A0_at_alliedsignal.com>#1/1
Ed Bradt wrote:
>
> Can VB through ODBC handle PL/SQL tables as parameters (in or out) for
> calls to stored procedures. Does the same limitation exist as with host
> language interfaces (Pro*C etc.) that only '1-dimensional' tables can be
> mapped to host arrays not tables of records?
>
> Thanks in advance
> Ed Bradt
Have you tried using Oracle Objects for OLE (OO4O) to connect you VB app to Oracle. OO4O does a direct connect to Oracle thru SQL*NET and does not need ODBC so performance is greatly enhanced. Maybe it has better options for PL/SQL procedure parameter passing.
John Thwaites
AlliedSignal - Polymers
Received on Wed Mar 11 1998 - 00:00:00 CET