-- List all Procedures and Functions in my schema...
SELECT DISTINCT type, name
FROM   user_source 
WHERE  type = 'PROCEDURE' or  type = 'FUNCTION';

-- Look at the code for one of the above...
SELECT text 
FROM   user_source
WHERE  name = '&name'
ORDER  BY line;