Re: PL/SQL Measurement Tool req'd.

> 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!)

Have a look at PL/Formatter from RevealNet (www.revealnet.com), besides formatting it produces a number of measures too, maybe not everything you want, but then talk to these guys.

Andre Received on Tue Dec 01 1998 - 00:00:00 CST