Oracle Objects for OLE 2.3 for Download
Date: 1998/11/04
Message-ID: <71qch4$86u$1_at_inet16.us.oracle.com>#1/1
Oracle Objects for OLE 2.3 (Trial version) is available for download from
the following sites
Minimal:
ftp://external-ftp.us.oracle.com/dev_tools/outgoing/oo4o/win32/23runtime/
Full:
http://www.oracle.com/products/trial/html/trial.html
The new features introduced in V2.3 are
Here is the short description for Oracle Objects for OLE
Oracle Objects For OLE (OO4O) is a product designed to allow easy access to data stored in Oracle databases from any programming or scripting language that supports the Microsoft COM Automation and ActiveX technology. This includes Visual Basic, Visual C++, Visual Basic For Applications (VBA), IIS Active Server Pages (VBScript and JavaScript), and others.
The OO4O Automation Server is a set of COM Automation objects for connecting
to Oracle database servers, executing SQL statements and PL/SQL blocks, and
accessing the results.
Unlike other COM-based database connectivity APIs, such as Microsoft ADO,
the OO4O Automation Server has been developed and evolved specifically for
use with Oracle database servers. It provides an optimized API for accessing
features that are unique to Oracle and are otherwise cumbersome or
inefficient to use from ODBC or OLE DB-based components.
OO4O provides key features for efficiently and easily accessing Oracle
databases in environments ranging from the typical two-tier client/server
applications (developed in Visual Basic or Excel, for example) to
application servers deployed in application server environments such as web
server applications in Microsoft Internet Information Server (IIS). Features
- Support for execution of PL/SQL anonymous blocks and stored
procedures. This includes support for for all data types allowed for
input/output parameters of PL/SQL stored procedures incluing PL/SQL
cursors.
- Free threaded objects and connection pooling for developing efficient
web server applications
- Support for array inserts and updates << link to description of SQLStmt and Parameter interfaces