Viewing the source of an Oracle stored proc

desc sys.dba_source
select text from sys.dba_source where name='your_stored_proc_name_here';