to list all the procedures and packages

[slimdave]

Originally posted by bhallar
select text from dba_source where owner in ('SCHEMA1', 'SCHEMA2')

... and order by owner, name, line