IBM Support

PI57119: RIT STORED PROCEDURE VIRTUALIZATION WITH ORACLE, CANNOT RETURN MANUALLY ADDED RESULT SET FROM VIRTUAL STORED PROCEDURE

Subscribe

You can track all active APARs for this component.

 

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