Oracle OleDb provider for Oracle (OraOLEDB.Oracle)

<< Click to Display Table of Contents >>

Navigation:  Getting Started > OLE DB providers >

Oracle OleDb provider for Oracle (OraOLEDB.Oracle)

Previous pageReturn to chapter overviewNext page

Problems with this provider

One of our customers has reported a problem returning OUT parameters from a Stored Procedure. Their workaround was to use the Microsoft provider (MSDAORA) for this part of the application.


When you use the ADOX Catalog object with Oracle, you should realize that the Tables and Indexes collection will return objects for ALL tables on the server. The collection may be huge, so use this with care. If you want to list the tables on the server for a particular database, you should consider using the OpenSchema() method of the AdoConnection class with an appropriate filter setting, to limit the number of rows returned.