ORA-06550: line 7729, column 23:
PLS-00123: program too large (Diana nodes)

Code Statistics Summary

Count  Statistic
-----  --------------

   *** Module Analysis
  303  Declarations
  773  Statements
   55  DML statements
   73  Stand-alone procedures
    3  Stand-alone functions
 6621  Code lines
 1418  Blank or comment lines

   *** Oracle Version Dependencies
  167  v7.1

   *** Declaration Analysis
    1  Variables with default value
  170  Variables without default value
    4  Constants
   43  Function declarations
    7  Procedure declarations
    2  Cursor declarations

   *** DML Analysis
   55  Implicit (SELECT INTO ) queries
   18  Maximum number of items in a SELECT list

   *** Cursor Analysis
   74  Cursor FOR loops using immediate SELECT
    2  Explicit cursor OPENs
    2  FETCH
    2  Explicit cursor CLOSEs
   35  Local program unit references to external variables

   *** Flow of Control Analysis
    1  EXIT statements in FOR loops
    5  Maximum number of nested IF levels

   *** Procedure/Function Analysis
    3  Maximum number of RETURN statements in a function
   11  Functions with OUT or IN OUT parameters
   73  Procedures declared without parameters
    7  Functions declared without parameters
    6  Maximum parameters in program units and cursors
   50  Local procedures and functions

   *** Exception Handling Analysis
   48  Exceptions blocks (EXCEPTION...)
  108  Exceptions handlers (WHEN...)
   48  WHEN OTHERS handler
   34  NO_DATA_FOUND
   26  TOO_MANY_ROWS

   *** Built-Ins Utilized
    1  ABS
    1  ADD_MONTHS
  979  CHR
   12  COUNT
   13  DECODE
    2  DUAL
    2  FLOOR
    4  INSTR
    3  LPAD
    3  LTRIM
   98  MAX
   15  MIN
    1  MONTHS_BETWEEN
   37  NULL
   41  NVL
    4  ROUND
   10  ROWNUM
    3  RPAD
   86  RTRIM
   86  SQLERRM
   61  SUBSTR
   13  SUM
  129  SYSDATE
   34  TO_CHAR
   16  TO_DATE
   16  TO_NUMBER
   99  TRUNC
   17  UPPER

   *** Built-In Packages Utilized
    1  DBMS_OUTPUT

   *** Comment Analysis
  589  Significant end-of-line comments
   40  Significant multi line comments
  201  Other comments

ALTER SESSION SET PLSQL_DEBUG = TRUE;

ALTER SESSION SET PLSQL_DEBUG = FALSE;

SELECT * FROM V$VERSION

SELECT banner 
FROM   v$version
/