Oracle Objects for OLE is a COM automation library that allows access to a Oracle Data Source using OLE, it should not be confused with Oracle Provider for OLEDB used for connecting to an ODBC Data Source. Please note: Only supported by Oracle 11.2 and below, consider using a standard method like Oracle Provider for OLEDB instead.
Oracle Objects for OLE (OO4O) allows you to access data stored in Oracle databases with any programming or scripting language that supports Microsoft COM Automation and ActiveX technology. Some of these include Visual Basic, Visual C++, Visual Basic for Applications (VBA), Active Server Pages (VBScript and JScript), and others that support COM automation.
For more information about Oracle Objects for OLE see the Official Documentation.
From Introducing Oracle Objects for OLE
Note: Oracle Database 11g Release 2 (11.2) is the last database version that supports Oracle Objects for OLE. Oracle Database versions, which are released after Oracle Database 11g Release 2 (11.2), will not support Oracle Objects for OLE. You can continue to use Oracle Objects for OLE with existing Oracle Database versions that are covered under the lifetime support policy of Oracle.
