Fixes are available
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