Oracle Objects for OLE Code Wizard for Stored Procedures

Overview

The Oracle Objects for OLE (OO4O) Code Wizard generates OO4O code that executes Oracle PL/SQL and Java stored procedures. OO4O is a COM-based database connectivity tool that provides seamless and optimized access to Oracle databases.

The wizard generates code into individual Microsoft Visual Basic or Active Server Page/VBscript subroutines from existing Oracle stored procedures and packages. Additionally, the wizard can generate complete implementations of COM Automation objects in the form of VB class files. The generated COM Automation object methods act as client stubs for the execution of stored procedures contained in a given package. All the OO4O code necessary for input/output parameter binding and stored procedure execution is automatically generated.

The wizard can be used as a command line utility or as a Visual Basic Add-in. The wizard automates the entire process of accessing stored procedures using COM interfaces, thereby significantly reducing development time and the likelihood of programming errors.

OO4O Code Wizard Components

The OO4O Code Wizard includes the following components:

Both these components allow users to generate OO4O code to access stored procedure packages.

Requirements

Supported Data Types

Using the OO4O Code Wizard

Examples