Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introducing Oracle COM Automation Feature

• Overview of 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
• Upgrading from Oracle Database 10g to Oracle Database 11g Release 1
• Upgrading from Oracle9i 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
• Configuring the Computer 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

• Data Type Conversions
  • Data Type Conversion for PL/SQL
  • Data Type 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 Oracle COM Automation Feature for 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

• Overview of Oracle COM Automation Feature for Java Demos
• 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