Re: ADO and Oracle PL/SQL Table

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/24/04


Date: Wed, 23 Jun 2004 22:04:16 -0400

Hi,

Yes, you could work with the Oracle using ADO. If you need some examples how
to work with Oracle, using ADO, then you could search Google or go to

http://support.microsoft.com/default.aspx?scid=FH;EN-US;KBHOWTO

select ADO in a Select a Microsoft product and type in "HOW TO ORACLE" for
the search condition. You will get list of the articles related to the
ADO+Oracle

-- 
Val Mazur
Microsoft MVP
"Pengguang Wu" <pgwu@exelixis.com> wrote in message 
news:OeiqVUHWEHA.1048@tk2msftngp13.phx.gbl...
> Hi All,
>
> Does anyone know whether you can fill an Oracle PL/SQL table using ADO in
> VB/VBA for updating an Oracle database? We have a commercial app that
> exposes a function with several PL/SQL tables as input parameters. Any
> suggestion to use this type of function is appreciated. Thanks,
>
> Best regards
>
> PG. Wu
>
> 


Relevant Pages

  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ... You should really only do this at design-time, or with a command you will ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Table open times and rowsize discontinuity
    ... some manner related to ADO or the tool you are using. ... Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text - ... For the array fetching, the only parameter I can find in the ADO ... exceeding the SDU and the MTU. ...
    (comp.databases.oracle.misc)
  • Re: OO4O 2.1 vs MDAC
    ... We're planning to move VB3 using OO4O 2.1 ... Now I must distinguish and list out some of the features that ADO / ... (OLE DB or ODBC) ... Also you don't mention the Oracle version there are differences between ...
    (microsoft.public.data.ado)
  • ADO.NET and ODBC { CALL ..... } Syntax
    ... Coonecting to Oracle 8i DB running on Unix ... ADO is used as connecting mechanism ... OleDB connection with provider as MSDAORA. ... Especially the using ODBC Call syntax to fetch the data either via Stored ...
    (microsoft.public.dotnet.framework.adonet)