Missing tables and procedures for Oracle Forms and Reports - 1.0

Compatibility: v2 v3 Express
What's new? Release Notes
ID: com.castsoftware.formsreport.missingtable

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

Language Supported?
Oracle Forms and Reports ✅

Transactions

Transaction support is derived from metamodel concepts used to build CAST Imaging Blueprint and structural transaction flows. Entry Points start transactions; Exit Points include both output/boundary concepts and Data Entities manipulated by transactions.

Role Support Breakdown
Entry Point No direct concept type details
Exit Point
  • Procedure
Data Entity with Accurate FP
  • Table
Data Entities
  • SQL Table - Unresolved

Data version: 1.0.4-funcrel

ISO 5055 Structural Rules

Quality support is based on ISO 5055 structural rules available for the selected extension version.

Reliability Maintainability Security Performance Efficiency

Data version: 1.0.4-funcrel

Prerequisites

Item Description
✅ An installation of any compatible release of CAST Core (see table above)
✅ An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.6.11-funcrel). Embedded tables were introduced in version 3.8.0-funcrel and system table in 3.8.1-funcrel.

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

Type Name Description
Embedded Procedure Embedded Procedure Represents a procedure or function declared or created in an Oracle Report query when it is missing from the analyzed DDL files.
Missing Procedure Missing Procedure Represents a procedure or function called by an Oracle Report query or Oracle Forms object but missing from the analyzed DDL or Forms and Reports files.
Missing Procedure SQL Missing Procedure Represents a missing procedure or function called by an Oracle Report query or Oracle Forms object when exactly one SQL schema is available.
Embedded Schema Embedded Schema Parent of embedded tables and procedures, attached to the Oracle Forms and Reports project.
Missing Schema Missing Schema Parent of missing tables and procedures, attached to the Oracle Forms and Reports project.
System Schema System Schema Parent of system tables, attached to the Oracle Forms and Reports project.
Embedded Table Embedded Table Represents a table created, dropped, altered, replaced, renamed, or declared in an Oracle Report query when it is missing from the analyzed DDL files.
Missing Table Missing Table Represents a table or view referenced by an Oracle Report query or Oracle Forms object but missing from the analyzed DDL or Forms and Reports files.
Missing Table SQL Missing Table Represents a missing table or view referenced by an Oracle Report query or Oracle Forms object when exactly one SQL schema is available.
System Table System Table Represents a system table or view referenced by an Oracle Report query but missing from the analyzed DDL files.
System Table SQL System Table Represents a system table or view referenced by an Oracle Report query when exactly one SQL schema is available.

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 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 Embedded Table / Missing Table / System Table / SQL Missing Table / SQL System 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
  • ddl/ddlCreate/ddlDrop/ddlAlter/ddlReplace from Oracle Report Query to Embedded Table