SQL & PL/SQL

Hi,

I would like to write a query on USER_SOURCE that can display the number of code lines for each procedure/function in a package.
Is it possible to write such a query? Maybe by using analytical functions?

for example in the following example i would like to count the lines between "PROCEDURE proc1 IS" and "END proc1;" and between "PROCEDURE proc2 IS" and "END proc2;"

SQL> select text  from user_source where name='PKG_TEST' and type='PACKAGE BODY';

TEXT
--------------------------------------------------
PACKAGE BODY PKG_TEST IS
/*************************************************
****/

  PROCEDURE proc1 IS
  BEGIN
    update t1 set EDITION_NAME = 'AAAAAAA';
    commit;
  END proc1;

PROCEDURE proc2 IS
  BEGIN
   update t1 set EDITION_NAME = 'AAAAAAA';

    commit;
  END proc2;
END PKG_TEST;

thanks for helping