Using Oracle Data Provider (ODP) With OLEDB and BUDBC Connections
The Oracle Data Provider should be used when connecting to Oracle databases using OpenBuildings Speedikon’s OLEDB. The ODP is also used for BUDBC Oracle connections.
Oracle Data types that are not supported by ODP |
---|
VARRAY |
MDSYS.SDO_GEOMETRY |
ORDSYS.ORDAudio |
ORDSYS.ORDImage |
ORDSYS.ORDImageSignature |
ORDSYS.ORDVideo |
ORDSYS.ORDDoc |
User Defined Objects |
In versions of the Oracle Data Provider earlier then 10.1.0.4.0 Oracle Client Patch set trying to retrieve these types cause a disconnect from the database. If you are aware that these types are being used in your database schema you should be using the ODP provided in the following patch sets or later versions.
Oracle Client Patchset 10.1.0.4.0 – Patch set Number 4163362
Oracle ODAC 10.1.0.4.0 – Patch set Number 4447340
For additional information on ODP Supported data types refer to the documentation listed below:
Oracle Provider for OLE DB Developer's Guide sections entitled "Datatype Mappings in Rowsets and Parameters" and "Table A-1 Datatype Mappings."
Release 9.2
Part Number A95498-01