Oracle Forms and Reports - 1.0


Extension ID

com.castsoftware.formsreport

What’s new?

See Release Notes.

Description

This extension provides support for the analysis of Oracle Forms and Reports applications, specifically for CAST Imaging v3.

Compatibility

Core release Operating System Supported
v3/8.4.x Microsoft Windows / Linux
v2/8.3.x Microsoft Windows

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
Function Points (transactions) Quality and Sizing

What about Oracle Forms and Reports in v2/8.3?

  • The com.castsoftware.formsreport extension is specific to CAST Imaging v3/8.4 and does not function with v2/8.3.
  • The extension should not be considered as an exact replacement for the Oracle Forms and Reports analyzer embedded in AIP Core 8.3 and you should note that there is no supported migration path between the two.
  • The support for Oracle Forms and Reports provided by the com.castsoftware.formsreport extension is similar to the supported provided by the Oracle Forms and Reports analyzer embedded in AIP Core 8.3, however it is not identical. If you would like to know more about the differences, please see Comparison with embedded Oracle Forms and Reports analyzer for Imaging v2/8.3.

Technical information

Supported releases of Oracle Forms and Reports

  • Oracle Forms 9i
  • Oracle Forms 10g
  • Oracle Forms 11g
  • Oracle Forms 12c
  • Oracle Forms 14c

Supported files for analysis

This extension supports the following files for analysis:

Native file type Description Accepted file type
.fmb Oracle Forms Binary File / Module File .xml
.mmb Oracle Forms Menu File .xml
.olb Oracle Object Library File .xml
.pll PL/SQL Library File .pld
.rdf Oracle Reports File .rex or .xml

In other words, you will need to convert your Oracle Forms/Reports files before you can deliver them for analysis. This conversion process is manual and is described in Source code preparation.

Source code discovery

The extension will “discover” one project (and configure one “Analysis Unit”):

  • if at least one of the following files is delivered for analysis:

    • .rex
    • .xml
    • .pld
  • and when at least one of the file types listed above contains content that matches the following regular expression:

MenuModule|FormModule|ObjectLibrary|report

What results can you expect?

Objects

Icon Object Type Description
Oracle Forms Module Object created from a FormModule tag.
Oracle Forms Function Object created with FUNCTION statements from a ProgramUnit in a xml file, DEFINE TOOL_PLSQL tag in a rex file or function tag in a Oracle Reports xml file. The same type cover Package’s function.
Oracle Forms Procedure Object created with PROCEDURE statements from a ProgramUnit in a xml file, DEFINE TOOL_PLSQL tag in a rex file or function tag in a Oracle Reports xml file. The same type cover Package’s procedure.
Oracle Forms Package Object created with PACKAGE statement from a ProgramUnit in a xml file, DEFINE TOOL_PLSQL tag in a rex file or function tag in a Oracle Reports xml file.
Oracle Forms Trigger Object created from a ProgramUnit, Trigger, DEFINE TOOL_PLSQL or a function tag.
Oracle Forms Window Object created from a Window, Alert or a LOV tag.
Oracle Forms DataBlock Object created from a Block tag.
Oracle Forms DataBlock Item Object created from an Item tag.
Oracle Forms Object Library Object created from an ObjectLibrary tag.
Oracle Forms PL/SQL Library Object created for a pld file.
Oracle Forms Menu Module Object created from a MenuModule tag.
Oracle Forms Menu Object created from a Menu tag.
Oracle Forms Menu Item Object created from a MenuItem tag.
Oracle Report Object created for a rex/xml file.
Oracle Report SQL Query Object created from a DEFINE SRW2_QUERY tag from a rzx file or a dataSource tag from a xml file.
Link Type Caller type Callee type Details / Comments
useSelect, useUpdate, useDelete, useInsert Oracle Forms Procedure, Oracle Forms Function, Oracle Forms Trigger, Oracle Report SQL Query, Oracle Forms Menu, Oracle Forms Menu Item, Oracle Forms DataBlock, Oracle Forms DataBlock Item, Oracle Forms Window Table, View, Synonym
call Oracle Forms Procedure, Oracle Forms Function, Oracle Forms Trigger, Oracle SQL Query, Oracle Forms Menu, Oracle Forms Menu Item, Oracle Forms DataBlock, Oracle Forms DataBlock Item, Oracle Forms Window Oracle Forms Procedure, Oracle Forms Function, Procedure, Function
call Oracle Forms Procedure, Oracle Forms Function, Oracle Forms Trigger, Oracle Report SQL Query, Oracle Forms Menu, Oracle Forms Menu Item, Oracle Forms DataBlock, Oracle Forms DataBlock Item, Oracle Forms Window Oracle Forms Module Via the built-in function call_form.
call Oracle Report Oracle Forms Function, Oracle Report SQL Query Each function and SQL query defined in a Oracle Report it belongs from the Oracle Report and it is seen as called by the Oracle Report
call Oracle Forms Procedure, Oracle Forms Function C/C++ Function For an Oracle Forms Procedure, Oracle Forms Function implemented in C/C++ (language C/C++), https://docs.oracle.com/cd/A58617_01/server.804/a58236/10_procs.htm#430175external link.
call Oracle Forms DataBlock object Oracle Forms Window object DataBlock is a CRUD Object, similar to an Entity Operation. CAST already produces a call link between C# Methods and an Entity Operations, therefore the same link type will also exist between the Oracle Window object and the Oracle Forms DataBlock object.
call Oracle Forms Menu Module Oracle Forms Menu When the MainMenu is specified, link the menu module with the menu.
call Oracle Forms Module Oracle Forms PL/SQL Library For the AttachedLibrary tag values.
monitor Oracle Forms Module, Oracle Forms DataBlock, Oracle Forms DataBlock Item Oracle Forms Trigger For the Oracle Forms Triggers which are not PRE/POST/ON-INSERT/UPDATE/DELETE triggers.
monitorInsert, monitorUpdate, monitorDelete Oracle Forms Module, Oracle Forms DataBlock, Oracle Forms DataBlock Item Oracle Forms Trigger For the PRE/POST/ON-INSERT/UPDATE/DELETE triggers.
inherit Oracle Forms Module object Oracle Forms Object Library object Link created based on the ParentModule and ParentName attributs.
relyon Oracle Forms Procedure, Oracle Forms Function Type, Table When parameter/variable datatypes are PL/SQL Type/Table/Table Columns.

Structural rules

Log messages

FORMSREPORT-001

Item Description
Identifier FORMSREPORT-001
Message 'Issue during link saving %s'. 'At line %s, during saving %s'. 'During saving %s'.
Severity Warning
Explanation This warning indicates an issue during the analysis which could mean that some links between objects will not be resolved.
User Action Contact CAST Support and provide the full warning message and impacted file.