SVGeek : Me, Life and Crazy World

Wednesday, May 12, 2004

Data Access and Storage Home: Accessing Oracle 9i Stored Procedures Using ADO.NET (ADO.NET Technical Articles)

Data Access and Storage Home: Accessing Oracle 9i Stored Procedures Using ADO.NET (ADO.NET Technical Articles)This article is a discussion of how to access Oracle stored procedures (named SQL programming blocks) and functions (which are programming blocks that return a single value) using ADO.NET.

You connect to an Oracle database using managed data providers, including the Microsoft® .NET Oracle Provider, the OLE DB .NET provider, the ODBC .NET data provider, or the ODP.NET provider from Oracle. This article uses the Microsoft® .NET Framework data provider for Oracle. Different functionality is available using the Oracle ODP.NET data provider or the Microsoft .NET Framework data provider for OLE DB.

The Oracle .NET data provider ships with the .NET Framework 1.1. If you are using .NET Framework 1.0, you will need to download the .NET Managed Provider for Oracle. For either version, the data provider classes are located in the System.Data.OracleClient namespace.

0 Comments:

Post a Comment

<< Home