to list all the procedures and packages

Hi people ! i wonder how to list all the source code for all the packages and procedures for a schema (or for all the database)
Someone knows how to do it from the sqlplus ?
Thxs a lot !!
Papik

select text from dba_source where owner in ('SCHEMA1', 'SCHEMA2')

YOU MEAN THE OBJECTS????

Quote:

---

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

---

... and order by owner, name, line