Contents

Title and Copyright Information

Before You Begin

1 Introducing Oracle COM Automation Feature

Introducing Oracle COM Automation Feature

What Is Oracle COM Automation Feature?

Benefits of Oracle COM Automation Feature

Oracle COM Automation Feature Architecture

Architectural Impact on Availability and Performance Issues

2 Installing Oracle COM Automation Feature

Oracle COM Automation Feature Contents

System Requirements

Installing Oracle COM Automation Feature

3 Post-Installation Configuration Tasks

Release 8.1.3 and Later Database Directory Trees

Configuring Oracle COM Automation Feature

Configuring the Listener

ORA-28575: Error Message

Configuring DCOM

4 Oracle COM Automation Feature Core Functionality

Oracle COM Automation Feature Core Functionality

Developing Solutions Using Oracle COM Automation Feature

Datatype Conversion

HRESULT Return Codes

PL/SQL Application Programming Interfaces

CreateObject

DestroyObject

GetLastError

GetProperty

SetProperty

InitArg

SetArg

SetPtrArg

Invoke

OLE Automation Errors

5 Using Oracle COM Automation Feature Demos

Oracle COM Automation Feature Demos Overview

Microsoft Word Demo

Installing the Microsoft Word Demo

Using the Microsoft Word Demo

Core Functionality

CreateWordObject

FileNew

FileLoad

FileSave

FileSaveAs

FileClose

InsertText

InsertNewLine

FormatFontSize

Microsoft Excel Demo

Installing the Microsoft Excel Demo

Using the Microsoft Excel Demo

Core Functionality

CreateExcelWorkSheet

InsertData

InsertChart

SaveExcelFile

ExitExcel

Glossary

Index