The Oracle Objects for OLE (OO4O) Code Wizard generates OO4O code that
executes Oracle PL/SQL and Java stored procedures.
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.
·Requirements·Supported Datatypes·Using the OO4O Code Wizard·Examples