IBM Support

PI53563: CANNOT EDIT STORED PROCEDURE DATA IN DATABASE STUB IF USING ORACLE SIMULATION DATABASE WHICH PREDATES ORACLE 11G

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Having created an Oracle stored procedure stub with an Oracle
    10g simulation database defined, select a row of data on the
    stub "Stored Procedures" tab and click the "edit row" picture
    button, and this error occurs:
    
    Caught SQL syntax error while attempting to edit the stub:
    'ORA-00904: "OBJECT_TYPE": invalid identifier
    '.
    The vendor-specific simulation database does not recognize this
    SQL syntax.
    This stub may be compatible with use of the integrated
    simulation database.
    Change the Database Stub settings on the physical resource to
    use the integrated simulation database and retry the edit.
    
    This happens because the code was written against Oracle 11g
    which has an OBJECT_TYPE in the SYS.ALL_PROCEDURES table and
    hence in the ALL_PROCEDURES public synonym which points at the
    table.
    

Local fix

  • The problem can be worked around by creating a view in the
    Oracle 10g simulation schema (and presumably in previous
    versions of Oracle). i.e.
    
    create view ALL_PROCEDURES as
    select "OWNER", "OBJECT_NAME", "PROCEDURE_NAME", null as
    "OBJECT_ID",
      null as "SUBPROGRAM_ID", null as "OVERLOAD", null as
    "OBJECT_TYPE",
      "AGGREGATE", "PIPELINED", "IMPLTYPEOWNER", "IMPLTYPENAME",
      "PARALLEL", "INTERFACE", "DETERMINISTIC", "AUTHID"
    from sys.all_procedures;
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester working with an     *
    * Oracle 10g simulation database                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Having created an Oracle stored procedure stub with an       *
    * Oracle                                                       *
    * 10g simulation database defined, select a row of data on the *
    * stub "Stored Procedures" tab and click the "edit row"        *
    * picture                                                      *
    * button, and this error occurs:                               *
    *                                                              *
    * Caught SQL syntax error while attempting to edit the stub:   *
    * 'ORA-00904: "OBJECT_TYPE": invalid identifier                *
    * '.                                                           *
    * The vendor-specific simulation database does not recognize   *
    * this                                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

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

    PI53563

  • 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

    2015-12-04

  • Closed date

    2016-05-26

  • Last modified date

    2016-05-26

  • 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:
14 October 2021