Fixes are available
APAR status
Closed as program error.
Error description
Build a stored procedure which returns a SYS_REFCURSOR in Oracle 11g and a Java program (using the RIT driver and Oracle driver) and record the invocation in RIT and build the stored procedure stub from the recording. Optionally modify the result set. Run the stub and invoke the stored procedure and all is well. Add a row to the stored procedure stub definition. The result is wrongly populated and must be overwritten with "OK". Populate the results set using column headings with the NAME(TYPE) format. Save this. Now relaunch the stub and invoke it with input parameters to reference the new row. The invocation will fail because the new results set (which can be seen in the simulation database) cannot be found be the simulation database stored procedure implementation.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of Rational Integration Tester working with RIT * * Stored procedure virtualization with Oracle * **************************************************************** * PROBLEM DESCRIPTION: * * Build a stored procedure which returns a SYS_REFCURSOR in * * Oracle * * 11g and a Java program (using the RIT driver and Oracle * * driver) * * and record the invocation in RIT and build the stored * * procedure * * stub from the recording. Optionally modify the result set. * * Run * * the stub and invoke the stored procedure and all is well. * * Add a * * row to the stored procedure stub definition. The result is * * wrongly populated and must be overwritten with "OK". * * Populate * * the results set using column headings with the NAME(TYPE) * * format. Save this. Now relaunch the stub and invoke it * * with * * input parameters to reference the new row. The invocation * * will * * fail because the new results set (which can be seen in the * * simulation database) cannot be found be the simulation * * database * * stored procedure implementation. * **************************************************************** * RECOMMENDATION: * * Upgrade to Rational Integration Tester v9.0.0.1 which * * includes a fix for this issue * ****************************************************************
Problem conclusion
A fix for this issue was provided in version 9.0.0.1 of Rational Integration Tester.
Temporary fix
Comments
APAR Information
APAR number
PI57119
Reported component name
RATL INTEGRA TE
Reported component ID
5725G79IT
Reported release
860
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-02-12
Closed date
2016-05-24
Last modified date
2016-05-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
RATL INTEGRA TE
Fixed component ID
5725G79IT
Applicable component levels
R800 PSN
UP
R801 PSN
UP
R850 PSN
UP
R851 PSN
UP
R860 PSN
UP
R870 PSN
UP
R871 PSN
UP
R900 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSBLQQ","label":"Rational Test Workbench"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.6","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
16 October 2021