Contents

Introducing Oracle Objects for OLE

Overview of Oracle Objects for OLE
About the OO4O Automation Server
About Oracle Data Control
About Oracle Objects for OLE C++ Class Library
New Features of Oracle Objects for OLE
Tips and Techniques for Performance Tuning

Requirements

Required Setups
OO4O File Locations
OO4O Redistributable Files
Demonstration Schema and Code Examples

Getting Started with the OO4O Automation Server

Basics of Client Applications
Accessing the OO4O Automation Server
Connecting to the Oracle Database
Detection of Lost Connections
Automation Objects
PL/SQL Support
Executing Commands
Asynchronous Processing
XML Data Interchange
Initializing Oracle LOBs, Objects, and Collections
Large Objects (LOBs)
Oracle Object Datatypes
Oracle Collections
Advanced Queueing Interfaces
Database Schema Objects
Application Failover Notifications
Database Events
Datetime and Interval Datatypes

Using OO4O with Automation Clients

Overview
With Visual Basic
With Excel
With Active Server Pages (ASP)
Oracle Data Control with Visual Basic
Oracle Data Control with MS VC++

OO4O Code Wizard for Stored Procedures

About the Code Wizard
Supported Datatypes
Using the OO4O Code Wizard
Code Wizard Examples

OO4O Automation Server Reference

Objects
Methods
Properties

Oracle Data Control Reference

Events
Methods
Properties

Troubleshooting

Error Handling
Troubleshooting