Contents

Title and Copyright Information

Contact Us!

How to Contact Oracle Technical Publications

How to Contact Oracle Support Services

Resources for Oracle Partners and Developers

Preface

Prerequisites

Intended Audience

How This Guide Is Organized

Conventions

Documentation Library

Related Documents

1 Introducing Oracle COM Automation

Introducing Oracle COM Automation Feature

Updates for Release 8.1.6

What Is Oracle COM Automation Feature?

Benefits of Oracle COM Automation Feature

Oracle COM Automation Feature Architecture

Invoking OLE Automation External Procedure APIs

Architectural Impact on Availability and Performance Issues

Oracle Database Availability

Oracle COM Automation Feature Performance

2 Installing Oracle COM Automation

Oracle COM Automation Feature Components

System Requirements

3 Post-Installation Configuration Tasks

Optimal Flexible Architecture for Oracle8i

Configuring Oracle COM Automation Feature

Configuring the Listener

ORA-28575: Error Message

Configuring DCOM

4 Oracle COM Automation Core Functionality

Oracle COM Automation Feature Core Functionality

Developing Solutions Using Oracle COM Automation

Information Required for COM Objects

OLE/COM Object Viewer

Datatype Conversion

HRESULT Return Codes

PL/SQL Application Programming Interfaces

CreateObject

DestroyObject

GetLastError

GetProperty

SetProperty

InitArg

SetArg

SetPtrArg

Invoke

Oracle COM Automation Errors

OLE Automation Errors

5 Using Oracle COM Automation Demos

Oracle COM Automation Feature Demos Overview

Microsoft Word Demo

Installing the Microsoft Word Demo

Using the Microsoft Word Demo

Core Functionality

Microsoft Excel Demo

Installing the Microsoft Excel Demo

Using the Microsoft Excel Demo

Core Functionality

Microsoft PowerPoint Demo

Installing the Microsoft PowerPoint Demo

Using the Microsoft PowerPoint Demo

Core Functionality

MAPI Demo

Installing the MAPI Demo

Using the MAPI Demo

Core Functionality

Glossary

Index