About the Code Wizard

Overview

The Oracle Objects for OLE (OO4O) Code Wizard generates OO4O code that executes Oracle PL/SQL and Java stored procedures.

NOTE: The Code Wizard requires Visual Basic 6.

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:

· A command line utility, OO4OCodeWiz.exe, that converts PL/SQL and Java stored procedures to OO4O code.

· A Visual Basic Add-in wizard that guides you through a series of steps to generate OO4O code for PL/SQL and Java stored procedures. The wizard displays Oracle packages and stored procedures from a tree control so that the user can choose which items to generate code.

Both these components allow users to convert entire stored procedure packages to OO4O code.

· Supported Datatypes

· Using the OO4O Code Wizard

· Examples