PL/SQL Measurement Tool req'd.

Dear all,

Our company needs an automated tool for gathering statistics about PL/SQL programming source code, wherever it resides: stored in Oracle Server database or as a part of Oracle Forms application (or other designed in Oracle Dev2000 app).

The subjects of interest are following statistics, counted for each function/procedure and summarised on a package level:
* lines of code

• number of variables
• cyclomatic complexity of each function/procedure
• number of functions/procedures in each package, private/public
• maximum level of nesting of IF/WHILE statements
• number of control variables
• other relevant PL/SQL information.

The task is to assess the logical complexity and structureness of PL/SQL code using similar approach to assessment of Cobol apps (McCabe metrics etc).
Please, it should not be a testing tool or a sort of profiler. The purpose is to assess _source_ code, statically by running the tool against source files stored as text (or, if the tool is capable to extract PL/SQL code directly from Oracle db or from Oracle Forms - it's welcome!)

Please, forgive me for some possible inaccuracy in Oracle terms and definitions - I'm not an Oracle guru.

Anyone who knows anything, please don't hesitate to contact me directly by email
ogorchko_at_vitgsysa.telecom.com.au
or
olpot_at_alphalink.com.au

thanks

Re,

Oleg Gorchkov
IBM GSA Received on Wed Nov 18 1998 - 00:00:00 CET