begin

  runstats_pkg.rs_start; 
  for i in 1..10000

  loop
   /*Method1 - procedure with bind variable which inserts data into table T*/
     method1('row '||I);
  end loop;

  runstats_pkg.rs_middle; 

  for i in 1..10000
   /*Method2 - procedure without bind variable which inserts data into table T*/
  loop
     method2('row '||I);
  end loop;

  runstats_pkg.rs_stop; 

end;

SQL> @d:\test.sql
      from v$statname a, v$mystat b
                         *
ERROR at line 3:
ORA-01031: insufficient privileges



Package created.


Warning: Package Body created with compilation errors.

SQL> desc v$statname

SQL> @d:\test.sql

View created.


Package created.


Warning: Package Body created with compilation errors.

SQL> show error
Errors for PACKAGE BODY RUNSTATS_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
11/5     PL/SQL: SQL Statement ignored
11/17    PL/SQL: ORA-00942: table or view does not exist
13/5     PL/SQL: SQL Statement ignored
13/17    PL/SQL: ORA-00942: table or view does not exist
24/5     PL/SQL: SQL Statement ignored
24/17    PL/SQL: ORA-00942: table or view does not exist
44/5     PL/SQL: SQL Statement ignored
44/17    PL/SQL: ORA-00942: table or view does not exist
52/5     PL/SQL: SQL Statement ignored
56/40    PL/SQL: ORA-00942: table or view does not exist
67/9     PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
67/31    PLS-00364: loop index variable 'X' use is invalid
78/5     PL/SQL: SQL Statement ignored
84/49    PL/SQL: ORA-00942: table or view does not exist
93/9     PL/SQL: Statement ignored
93/31    PLS-00364: loop index variable 'X' use is invalid
SQL> desc v$timer
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

create global temporary table run_stats
( runid varchar2(15),
  name varchar2(80),
  value int )
on commit preserve rows;