Contents

Title and Copyright Information

Preface

Audience

Documentation Accessibility

Related Documents

Conventions

What's New in Oracle COM Automation Feature?

Oracle Database 10g Release 2 (10.2) New Features in Oracle COM Automation Feature

Oracle Database 10g Release 1 (10.1) New Features in Oracle COM Automation Feature

Oracle Release 9.2 New Features in Oracle COM Automation Feature

Oracle9i New Features in Oracle COM Automation Feature

Oracle Release 8.1.6 New Features in Oracle COM Automation Feature

1 Introducing Oracle COM Automation Feature

Introduction to Oracle COM Automation Feature

Oracle COM Automation Feature Functionality

Oracle COM Automation Feature for PL/SQL

Oracle COM Automation Feature for Java

Benefits of Oracle COM Automation Feature

Oracle COM Automation Feature Architecture

PL/SQL Architecture

Invoking COM Automation External Procedure APIs

Architectural Impact on Availability Issues

Java Architecture

Reliability

2 Installing and Configuring Oracle COM Automation Feature

Oracle COM Automation Feature Components

PL/SQL Components

Java Components

System Requirements

Migration from Oracle9i to Oracle Database 10g

Migration from Oracle8i to Oracle Database 10g

Configurations for Oracle COM Automation Feature

Configuring Oracle COM Automation Feature for PL/SQL

Configuring Oracle COM Automation Feature for Java

Configuring the Listener for PL/SQL

Troubleshooting Listener Problems

Support for DCOM

Configurations for the Computer Running the Database Instance

Setting Services to a Domain User

Configuring the Computer Containing the Remote Object

3 Oracle COM Automation Feature Core Functionality

Datatype Conversions

Datatype Conversion for PL/SQL

Datatype Conversion for Java

HRESULT Error Codes

PL/SQL Use of HRESULT

Java Use of HRESULT

Oracle COM Automation for Java Exception Handling

Typical COM Automation Functionality

Information Required for COM Objects

OLE/COM Object Viewer

Using COM Automation Feature APIs

Application Programming Interfaces

PL/SQL APIs

Java APIs

PL/SQL APIs

CreateObject

DestroyObject

GetLastError

GetProperty

SetProperty

InitArg

InitOutArg

GetArg

SetArg

Invoke

Java APIs

Automation Constructor

Create

Destroy

GetProperty

SetProperty

InitArg

SetArg

Invoke

Currency Constructor

Get

Set

4 Oracle COM Automation PL/SQL Demos

Overview of PL/SQL Demos

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

Setting Up the Environment to Use the MAPI Demo

Preparing to Install MAPI Demo

Installing the MAPI Demo

Using the MAPI Demo

Core Functionality

5 Oracle COM Automation Java Demos

Oracle COM Automation Feature Java Demos Overview

Microsoft Word Java Demo

Installing the Microsoft Word Java Demo

Using the Microsoft Word Java Demo

Creating a Custom Application

Core Functionality

A COM Automation Error Messages

Oracle COM Automation Feature, PL/SQL Errors

Microsoft COM Automation Errors

Glossary

Index