2 Release Information

The Oracle Procedural Gateway Visual Workbench for WebSphere MQ is used with the Oracle Procedural Gateway for message queuing products. This release supports release 2 (10.2) of the Oracle Procedural Gateway for WebSphere MQ. For more information, see the Oracle Procedural Gateway for WebSphere MQ Installation and User's Guide for Microsoft Windows for your platform.

This release supports automatic data conversion between only two types of application, Oracle PL/SQL applications and IBM VS/COBOLII applications. You can add other data conversions manually.

This chapter contains the following sections:

Product Set
Migration Considerations
Changes and Enhancements, Release 10.2.0.1.0
Known Problems

2.1 Product Set

These components are included on the product installation media:

Product	Release Number
Oracle Universal Installer	2.0.1.6.0
Oracle Procedural Gateway Visual Workbench for WebSphere MQ	10.2.0.1.0
Oracle Net	10.2.0.1.0

This release replaces Oracle Procedural Gateway Visual Workbench for WebSphere MQ release 9.0.1.1.1 and earlier, which used a client/server system.

2.2 Migration Considerations

The message interface package (MIP) described in Chapter 7, "Using the Generated MIP", is not compatible with the MIP generated by the Visual Workbench release 9.0.1 and earlier. You must modify applications that use release 9.0.1 and earlier releases of the MIP.

The Visual Workbench repository is not compatible with the repository released with the Visual Workbench releases 9.0.1 and earlier. You must re-create interface profiles that were created and stored in the repository using releases 9.0.1 and earlier.

2.3 Changes and Enhancements, Release 10.2.0.1.0

There is only one enhancement in this release.

2.3.1 Accessing release 10.2.0.1.0 and all earlier releases of PG4MQ Visual Workbench Repositories.

The current release of the Oracle Procedural Gateway Visual Workbench for WebSphere MQ is enhanced to be able to access release 10.2.0.1.0 and all earlier releases of PG4MQ Visual Workbench repositories.

2.4 Known Problems

The description of problems includes suggestions for dealing with them when possible. If you have questions or concerns about the problems, then contact Oracle Support Services. A current list of problems is available online. Contact your local Oracle office for information about accessing this list.

2.4.1 Maximum Open Cursors

This error might appear during a PG4MQ Visual Workbench operation:

ORA-01000: Maximum open cursors exceeded

Most Visual Workbench operations do not work correctly after this error, and the error continues to appear. To resolve this problem, set the CLOSE_CACHED_OPEN_CURSOR initialization parameter to TRUE for the Oracle server where the Visual Workbench repository resides.

2.4.2 Incorrect Precision of PL/SQL Data Types

The COBOL to PL/SQL map panel occasionally lists an incorrect precision for the PL/SQL data types shown. To see the correct PL/SQL precision, view the generated PL/SQL code of a MIP to which the COBOL data profile was added. Select the data mapping entry from the list on the PL/SQL Code panel for the MIP and click View.... The PL/SQL package specification includes the data type definitions generated and shows the correct precision of each data type.

2.4.3 The MIP Is Too Large

When creating an interface profile or adding data profiles to an interface profile, the MIP can become larger than the PG4MQ Visual Workbench can handle. The PG4MQ Visual Workbench reports this error as follows:

ORA-20004: Message Interface Package getting too large.