Missing tables and procedures for Oracle Forms and Reports - 1.0

Description

This extension is designed to analyze SQL queries embedded in Oracle Forms and Reports code and create “missing” SQL and Oracle Forms and Reports table / procedure objects to represent SQL objects that have not been delivered for analysis. Links to these objects are also created. The primary goal of the extension is to ensure that a full transaction is identified by CAST, resulting from the SQL queries embedded / PL/SQL code in the Oracle Forms and Reports code, even if none or only part of the referenced SQL objects are delivered for analysis.

Supported client languages

Function Point, Quality and Sizing support

• Function Points (transactions): a green tick indicates that OMG Function Point counting and Transaction Risk Index are supported
• Quality and Sizing: a green tick indicates that CAST can measure size and that a minimum set of Quality Rules exist

Prerequisites

Download and installation instructions

The extension will be automatically downloaded and installed in CAST Console when Oracle Forms and Reports source code is delivered for analysis. You can manage it using the Application - Extensions interface.

What results can you expect?

Objects

Icon	Object Type	Description	Metamodel Type
	Missing Schema	Parent of the missing tables and procedures, attached to the Oracle Forms and Reports Project.	CAST_FormsScript_MissingTable_Schema
	Missing Table	A table or a view selected/updated/deleted/inserted in a Oracle Report Query / Oracle Forms Trigger / Oracle Forms DataBlock / Oracle Forms DataBlock Item / Oracle Forms Procedure / Oracle Forms Function / Oracle Forms Menu / Oracle Forms Menu Item / Oracle Forms Window missing from the DDL file.	CAST_FormsScript_MissingTable_Table
	Missing Procedure	A procedure or a function called in a Oracle Report Query / Oracle Forms Trigger / Oracle Forms DataBlock / Oracle Forms DataBlock Item / Oracle Forms Procedure / Oracle Forms Function / Oracle Forms Menu / Oracle Forms Menu Item / Oracle Forms Window missing from the SQL DDL/Oracle Forms and Reports file.	CAST_FormsScript_MissingTable_Procedure
	SQL Missing Table	A table or a view selected/updated/deleted/inserted in a Oracle Report Query / Oracle Forms Trigger / Oracle Forms DataBlock / Oracle Forms DataBlock Item / Oracle Forms Procedure / Oracle Forms Function / Oracle Forms Menu / Oracle Forms Menu Item / Oracle Forms Window missing from the DDL file, but we have a SQL Schema, and only one.	SQLScript_Missing_Table
	SQL Missing Procedure	A procedure or a function called in a Oracle Report Query / Oracle Forms Trigger / Oracle Forms DataBlock / Oracle Forms DataBlock Item / Oracle Forms Procedure / Oracle Forms Function / Oracle Forms Menu / Oracle Forms Menu Item / Oracle Forms Window missing from the DDL file / Oracle Forms and Reports file but we have a SQL Schema, and only one.	SQLScript_Missing_Procedure

Links

Links are created for transaction and function point needs. You can expect the following links on the Oracle Report Embedded SQL queries / Oracle Report Query / Oracle Forms Trigger / Oracle Forms DataBlock / Oracle Forms DataBlock Item / Oracle Forms Procedure / Oracle Forms Function / Oracle Forms Menu / Oracle Forms Menu Item / Oracle Forms Window:

• useSelect/useUpdate/useDelete/useInsert from Oracle Oracle Report Query / Oracle Forms Trigger / Oracle Forms DataBlock / Oracle Forms DataBlock Item / Oracle Forms Procedure / Oracle Forms Function / Oracle Forms Menu / Oracle Forms Menu Item / Oracle Forms Window to Missing Table/SQL Missing Table
• call from Oracle Report Query / Oracle Forms Trigger / Oracle Forms DataBlock / Oracle Forms DataBlock Item / Oracle Forms Procedure / Oracle Forms Function / Oracle Forms Menu / Oracle Forms Menu Item / Oracle Forms Window to Missing Procedure/SQL Missing Procedure