Hi

Offcourse the procedures are stored in the database until and unless you have explicity saved them on the hard disk which usually everybody does.But you can have look at what procedures are available on your database using the following query

select * from user_source;

select * from all_source;

select * from dba_source;

Regards